Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “isobars” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

162 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
isobars93659(None) 
isobar836141isobar_
isobare946341isobare
isobares1046511isobares
disbars10310322dis_bars
isbas71010402is_ba_s
isobaric1244752isobaric
isobarism1343832isobarism
isobath1244612isobath
isobaths1343832isobaths
isomers9310042isomers
kilobars1444932kilobars
soars54732512_so_ars
sobas74424252_soba_s
sobers85218862_sobers
sofars94712782_sofars
sonars64818972_sonars
sowars94318012_sowars
allobars1046583allobars
ashlars10297063ashlars
baobabs1044443baobabs
bars66564093___bars
boars75229603_bo_ars
boyars115611983_boyars
busbars1138153busbars
cobras104014193_cobras
costars94218013costars
crowbars1544443crowbars
darbars10510093darbars
debars94218043_debars
deodars937623deodars
disbar938513dis_bar_
disobeys1443683disobeys
disrobers1246383disrobers
dobras94811913_dobras
durbars1077973durbars
embars103812883_embars
escars83913133es_cars
eschars1237183eschars
escolars1045343escolars
eskars10357593es_kars
eyebars1245333eyebars
gobans94412043_gobans
goobers10219623goobers
hoars85925553_ho_ars
imbark14347863i_mbark
imbarks15326613i_mbarks
inboard1037063inboard
inboards1145843inboards
insofar1043543insofar_
instars7411133instars
insulars8137323insulars
invars9310003i_nvars
iotas54821113i_ota_s
ironbark1443063ironbark
ironbarks1542703ironbarks
ironers74813553ironers
isallobars1251543isallobars
isba61310883is_ba__
isobarisms1443093isobarisms
isochors1355673isochors
isoform1244963isoform
isoforms1344343isoforms
isogamy1343993isogamy
isogons8217613isogons
isogram1047253isogram
isograms1146473isograms
isohels1035393isohels
isolate7313923isolate
isolates8613513isolates
isolators947513isolators
isoleads944373isoleads
isologs837433isologs
isomer8310153isomer_
isopach1444243isopach
isopachs1543243isopachs
isopods1045573isopods
isotach1244953isotach
isotachs1343773isotachs
issuers746123issuers
ixoras1337193ixora_s
izars145112933i__zars
jowars16369653_jowars
kabars124513953_kabars
kbars114612603__kbars
kebars124112493_kebars
kilobar1344613kilobar_
lobar7313013_lobar_
lumbars11289763lumbars
microbars1546883microbars
mimbars1397383mimbars
minibars1296553minibars
mishears1338323mishears
molars85517323_molars
oars46846033__o_ars
obas65730933__oba_s
polars84419353_polars
probers113514583probers
psoas75012983pso_a_s
psywars1533673psywars
rebars84019833_rebars
roars55622243_ro_ars
sabals84618863_sabals
sabers85224733_sabers
sabirs85414633_sabirs
sabras85116363_sabras
sambars115113843sambars
scars75433533_s_cars
sears54744913_s_ears
sewars94018633_sewars
shears93820903_shears
shofars1335833shofars
sidebars1146643sidebars
simars84916933_simars
sirdars8228213sirdars
sitars65417593_sitars
sizars154812623_sizars
smears84714433_smears
soaks95220293_so_aks
soaps75120713_so_aps
soar46838673_so_ar_
soba64927923_soba__
sobbers114114263_sobbers
sober74822413_sober_
sobs64941753_sob__s
socas74026183_soca_s
sodas64123543_soda_s
sofar86115493_sofar_
sofas85320713_sofa_s
sojas124716393_soja_s
solans64122493_solans
solar55927343_solar_
somans84619303_somans
somas76030373_soma_s
sonar56523423_sonar_
sopors85215203_sopors
soras55041013_sora_s
souari6311383_souari
souaris7312333_souaris
soucars938423_soucars
sours55230503_so_urs
sowans94215893_sowans
sowar85821343_sowar_
sowcars1236013_sowcars
sowers94923443_sowers
soyas84520913_soya_s
spars75431543_s_pars
spears84019473_spears
stars55836573_s_tars
subahs114512383_subahs
subas74724073_suba_s
subers85722643_subers
sugars7312423_sugars
swears94114073_swears
taskbars1452993taskbars
tolars64817943_tolars
toolbars1044743toolbars
trocars959043trocars
tsars56717113ts__ars
unbars82113033_unbars
upsoars985413upso_ars
visors92912223viso__rs

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.393454684.5
2DLD Change Limit1340271626.84319586.0
3Display Results1621620.0602700.0
 (SQL Overall)1786911627.29624491.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.