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 “navaids” 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.

147 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
navaids113480(None) 
navaid1037641navaid_
avails939692_avails
avoids104410202_avoids
naiads739012naia_ds
navars92810572nava_rs
navies95218622nav_ies
navvies1335322navvies
acarids105312243_acarids
acids87121003_a_cids
agamids11317003_agamids
aids57846353___aids
alands75418373_alands
alcids94812293_alcids
amids85627513_a_mids
antacids1148323antacids
anvils9219713anv_ils
aphids125110843_aphids
aramids102810503_aramids
aroids75118223_aroids
avail8313883_avai_l
avians93711563_avians
avid88325963_av_id_
avoid95516673_avoid_
awaits96411953_awaits
awards107113453_awards
barmaids1345933barmaids
bayards13379683bayards
bovids1287973bov_ids
braids95015683_braids
caids85226423__caids
camails11311743camails
canards10311203canards
candids113812693candids
canids95118133ca_nids
capsids1239333capsids
carabids1338183carabids
caviars1238623caviars
cavies114525003cav_ies
cavils114014393cav_ils
davies105020513dav_ies
davits104012363dav_its
farads104713273fara_ds
favas115618593fava__s
gadids95611823ga_dids
gadoids1036863gadoids
ganoids939323ganoids
gavages1237683gavages
gavials1136603gavials
halids104016133ha_lids
haloids113012543haloids
hazards2037463hazards
invalids1244733invalids
jassids1586143jassids
javas155915423java__s
kavas125919953kava__s
kavass13517303kava_ss
lanais6316793lanai_s
lavabos1235453lavabos
lavages1138603lavages
lavas85422223lava__s
maids86327143__maids
mantids103113623mantids
marauds1037553marauds
masjids17175403masjids
mavies114923193mav_ies
mavins115119183mav_ins
mavis105622723mav_i_s
mazards1937703mazards
naans55815253na_a_ns
nabis76020583na_bi_s
nadas66320813nada__s
nadirs7109003na_dirs
naevoid1194593naevoid_
naganas847983naganas
naiad6313403naia_d_
naiades838213naiades
naifs87617423n__aifs
nails55730403n__ails
nalas55528363nala__s
naleds7469133na_leds
nanas55928633nana__s
nancies93516843nancies
nandins8312003nandins
nankins1159053nankins
nannies73015203nannies
napalms1144033napalms
napas75924353napa__s
napkins1336673napkins
nappies114613393nappies
nards65928463n__ards
naris55735293na_ri_s
nasals63312463nasa_ls
nasties73520493nasties
naval85315833nava__l
navally1366473navally
navar83912733nava__r
navels95712693nav_els
naves87030383nav__es
nawabs1185063nawa_bs
naysaid1145303naysaid_
nazis145216083na_zi_s
nereids838743nereids
nevoid1098793nevoid_
nicads938333nica_ds
nitrids8269633nitrids
nomads94711603noma_ds
nonacids11148253nonacids
novas85215363nova__s
ovoids10456923_ovoids
palais8420423palai_s
papains11312363papains
pavanes123612653pavanes
pavans115715593pava_ns
pavid115717003pav_id_
pavins114919663pav_ins
pavis106422733pav_i_s
plaids94312443_plaids
qaids156116313__qaids
raids65827513__raids
ranids75118703ra_nids
rapids94913893ra_pids
ravages1139403ravages
ravins94622563rav_ins
reavails1134853reavails
saids65328853__saids
saiyids11174893saiyids
salads75316963sala_ds
salpids1038193salpids
savages1139973savages
savants1038653savants
savarins1139893savarins
savates10312953savates
savins93923133sav_ins
savvies1337603savvies
sayids104310973sa_yids
sayyids14193833sayyids
tabanids1144963tabanids
tabards10310383tabards
travails1146083travails
unbraids1144953unbraids
vails85825933__vails
vairs85019133__vairs
vawards14457573vawards
vids85627533__v_ids
voids95414673__voids
wavies125019843wav_ies

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.1561145455.1
2DLD Change Limit1340271477.54617761.3
3Display Results1471470.0463195.7
 (SQL Overall)1786911477.74823062.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.