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

159 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
admixt163733(None) 
admit8319491admi_t
admix1557731admix_
addict10711202addict
adit56443652ad_i_t
admire949932admire
admits9411412admits
admixed1833732admixed
admixes1765962admixes
adrift10313112adrift
bemixt174510362bemixt
mixt136831922__mixt
remixt155014852remixt
unmixt15378702unmixt
acmic11312333acmi_c
adamant101110443adamant
adapt81218553ad_apt
addax1435993addax_
addicts1176013addicts
adding93914963adding
adduct1087373adduct
adept81219643ad_ept
adhibit1345343adhibit
adieu6417423ad_ieu
adios65822863ad_ios
adits66523713ad_its
adjoint15108283adjoint
adjust1447183adjust
adman84517903adm_an
admass957143admass
admen84516183adm_en
admiral1046363admiral
admired1135703admired
admirer1035523admirer
admires1038663admires
admitted1234763admitted
admittee1145133admittee
admitter1135113admitter
admixing1944133admixing
admixture1952103admixture
adnexa1433673adnexa
adopt81219743ad_opt
adroit7518793adroit
adult63520653ad_ult
adust64117453ad_ust
advect12309123advect
advent102613753advent
advert103215783advert
advice12107883advice
advise10139223advise
adzing174110013adzing
affix1836003affix_
afrit8323173afri_t
ageist7315383ageist
agist66325583a_gist
aiming94320843aiming
airt45757783a__irt
ait38093903a__i_t
alist56136783a_list
alit46155693a_li_t
almost81014433almost
ambit94223713a_mbit
ament76036543a_ment
ami56646813a_mi__
amia66836903a_mi_a
amias75831473a_mias
amice96122873a_mice
amici94217393a_mici
amid77036353a_mi_d
amide86128483a_mide
amido85720983a_mido
amids85627513a_mids
amidst94913233a_midst
amie66339853a_mi_e
amies76837693a_mies
amiga85514813a_miga
amigo86515473a_migo
amin66042253a_mi_n
amine75835383a_mine
amino75425503a_mino
amins75534323a_mins
amir65129753a_mi_r
amirs75924923a_mirs
amis66445323a_mi_s
amiss75823073a_miss
amity10416093a_mity
ammine10314493ammine
ammino1069883ammino
amort75832203a_mort
animist93815173animist
anoint6423633anoint
aorist64827873aorist
apomict1349053apomict
armet76739453arm_et
armies85123693armies
arming94719803arming
armlet84118193armlet
armpit10811093armpit
aroint6328153aroint
artist64125543artist
assist6314603assist
atilt54828473a_tilt
atomist92915763atomist
audit62527883audi_t
aurist65027253aurist
autist64324943autist
await85524493awai_t
bemist105216963bemist
bemix165011453bemix_
cadmic1338983cadmi_c
cadmium1446113cadmium
catmint11314463catmint
coadmit1247833coadmi_t
comix163513203comix_
commixt20357623commixt
dadaist9310103dadaist
dammit11311133dammit
davit93424593davi_t
deist64633593_deist
demit84832303demi_t
diet57357533_d_iet
dint56759053_d_int
dipt77339323_d_ipt
dirt55550383_d_irt
dit47071333_d_i_t
dixit134420593_d_ixit
doit56347853_doi_t
drift95722843_drift
dript86923873_dript
duit56241583_dui_t
edict84722283ed_ict
edit54934863ed_i_t
emit65438423_emi_t
faddist12289643faddist
fixt1410729713__fixt
idiot6718863id_iot
immix1635033immix_
limit73126343limi_t
milt65455813__milt
mint66758063__mint
mist66154533__mist
mitt66145493__mitt
mix126138183__mix_
odist6421913od_ist
omit65337373_omi_t
palmist112814343palmist
premixt183510663premixt
radix134414603rad_ix_
readmit1039823readmi_t
remint85329983remint
remit75737223remi_t
remix145916553remix_
sadist74221353sad_ist
smit65138413_smi_t
twixt155512483_twixt
unfixt16398423unfixt
unmix14388973unmix_
varmint12311683varmint
vomit102622573vomi_t

Search took 7 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161595.62620034.8
3Display Results1591590.0602650.0
 (SQL Overall)1786911596.05929491.8
 
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.