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

187 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
gadoids103687(None) 
gadids95611821gad_ids
gadoid9310461gadoid_
ganoids939331ganoids
aroids75118222_aroids
avoids104410202_avoids
gaddis94211372gaddi_s
gadid85517382gad_id_
gadis74825292gad_i_s
ganoid8314442ganoid_
geoids8369842g_eoids
haloids113012552haloids
acids87121003_a_cids
adds67622453_ad__ds
adenoids1056863_adenoids
adios65822863_ad_ios
adits66523713_ad_its
adjoins1585983_adjoins
admits9411413_admits
adobes94411533_adobes
adobos9438453_adobos
adonis7314063_adonis
adopts998083_adopts
adores74420723_adores
adorns74212613_adorns
ados57633513_ado__s
agamids11317013agamids
agatoid948623agatoid_
aholds10469483_aholds
aids57846363_a__ids
alcids94812293_alcids
aloins65022203_aloins
amids85627513_a_mids
androids1047753androids
aphids125110843_aphids
apods86316343_apo_ds
aroid65428343_aroid_
avoid95516683_avoid_
baddies114017873baddies
caddies113718383caddies
caddis104613383caddi_s
cadis84428503cad_i_s
caids85226423ca__ids
candids113812693candids
canids95118133ca_nids
capsids1239333capsids
cardioids1345243cardioids
carotids11229953carotids
ceboids1237653ceboids
conoids10813883conoids
cuboids1236723cuboids
dacoits1079073dacoits
daddies103414943daddies
dadoed9449903dadoed_
dadoes85616533dado_es
dadoing1038523dadoing
dados75522433dado__s
dakoits1245293dakoits
doits66223673__doits
droids84712583_droids
factoids1446243factoids
fadeins1168503fadeins
fados95620733fado__s
fucoids1335663fucoids
gabies93820733ga_bies
gabions102410053gabions
gaboons10289903gaboons
gadded103913173gadded_
gadders103611503gadders
gaddi85211633gad__di
gadding113411453gadding
gadflies1334733gadflies
gadgets10348683gadgets
gadi66329723gad_i__
gadroons1037013gadroons
gads67843383ga___ds
gadzooks23112933gadzooks
gains65729513ga__ins
gaits65726013ga__its
galiots82311323galiots
gallies84122713gallies
galoots82410793galoots
galops94712623galo_ps
galores82614343galores
gambias125010733gambias
gambirs12359083gambirs
gambits12399723gambits
gamins94420053ga_mins
ganofs104010293gano_fs
gaols66717573ga_o_ls
gaposis1038423gaposis
garboils1145663garboils
garlics1038013garlics
garotes8614563garotes
gaskins123510773gaskins
gators74115843gato_rs
gaudies9311973gaudies
gauds75717723ga__uds
gavots1038113gavo_ts
gawkies15429123gawkies
gazoos163010223gazo_os
geoid74215763g_eoid_
giddies103713363giddies
gids65933743g___ids
globoids1244413globoids
goads77022853g__oads
gobioids1243873gobioids
godhoods1444173godhoods
godowns1234673godowns
gods65438043g__o_ds
godwits1234133godwits
golds75421313g__olds
goodies93516993goodies
goods75124483g__oods
gowds105814043g__owds
gradins93416233grad_ins
grandkids1643143grandkids
grids75321393g__rids
groins73917203g_roins
guids75516153g__uids
hadjis17439653hadji_s
halids104016133ha_lids
haloid104317763haloid_
haploids1437363haploids
hyaloids1545993hyaloids
hydrids15267233hydrids
hydroids1647763hydroids
hyoids1377673_hyoids
iodids83711153iod_ids
ixodids16213363ixodids
jassids1586143jassids
kadis105921063kad_i_s
keloids1288663keloids
kidvids1643113kidvids
labroids1155843labroids
laddies93715053laddies
ladhoods1345873ladhoods
ladies75124883lad_ies
lipoids1038233lipoids
loids66220703__loids
maids86327143ma__ids
mantids103113623mantids
masjids17175403masjids
mastoids1177873mastoids
mattoids1196183mattoids
meloids10911453meloids
mucoids1237423mucoids
nadirs7109003nad_irs
navaids1134803navaids
ogdoads1042993ogdoads
opioids1036523opioids
ovoids10456923_ovoids
paddies113715723paddies
padis86227143pad_i_s
padouks1434873padouks
pagods105310193pago_ds
parotids112610413parotids
patois84319363patoi_s
placoids1347343placoids
qadis155917853qad_i_s
qaids156116313qa__ids
radios74018673rad_ios
radius73914873rad_ius
radomes10311053radomes
radons74118533rado_ns
raids65827513ra__ids
ranids75118703ra_nids
rapids94913893ra_pids
sadis64930853sad_i_s
saids65328853sa__ids
saiyids11174893saiyids
salpids1038193salpids
sarcoids1137803sarcoids
sarods74918573saro_ds
sayids104310973sa_yids
sayyids14193833sayyids
sloids73712693_sloids
sparoids11218713sparoids
tabloids1146163tabloids
toroids8310653toroids
toxoids1535213toxoids
viroids1137923viroids
voids95414673__voids
waddies124214753waddies
wadies105121203wad_ies
wadis95223963wad_i_s
zooids1637093_zooids

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.423422437.4
2DLD Change Limit1340271876.96619240.2
3Display Results1871870.0632968.3
 (SQL Overall)1786911877.45223978.9
 
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.