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

232 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
immix163501(None) 
admix1557722admix
bemix165011452bemix
comix163513192comix
commix19407752commix
gimmie11298172gimmie
imid76122272i_mid
immies102412422immies
immixed1933562immixed
immixes1835062immixes
immy114611822imm_y
impi85415772impi_
impis96213832impis
infix15337762infix
jimmie17376462jimmie
mimic111414312mimic
mix126138172__mix
remix145916552remix
unmix14388972unmix
wimmin1336142wimmin
acmic11312333acmic
admit8319493admit
admixt1637333admixt
affix1836003affix
amain74922883amain
ambit94223693ambit
ami56646803_ami_
amia66836893_amia
amid77036333_amid
amie66339843_amie
amin66042243_amin
amir65129743_amir
amis66445313_amis
ammine10314483ammine
ammino1069873ammino
ammo85520133amm_o
ammos94815823ammos
amnia75918633amnia
amnic95516233amnic
amnio75218043amnio
bemixt174510363bemixt
calix145317343calix
cammie124615293cammie
cimex16119133cimex
comic114721813comic
commie124215523commie
commit124016703commit
commixt20357623commixt
cumin94616973cumin
cummin1288783cummin
cylix17448623cylix
dammit11311133dammit
demic105119193demic
demit84832303demit
diamin9312513diamin
dimmed124110323dimmed
dimmer114112613dimmer
dimming13339583dimming
dimwit1237943dimwit
domic104317243domic
email74715093email
emic86422743_emic
emir65918693_emir
emit65438413_emit
emmer94314463emmer
emmet94221383emmet
emmy116013243emm_y
emmys12446023emmys
filmi105914003filmi_
filmic13348453filmic
filmis114610283filmis
fix136236103__fix
gamic103916193gamic
gamin84422993gamin
gimmal11247513gimmal
gimme102411343gimm_e
gimmes113010903gimmes
gimmick1843263gimmick
gimmies123010103gimmies
helix154413013helix
hemic125718623hemic
hemin103620933hemin
hmm106218993hmm__
homie104622523homie
humic124113243humic
humid114213763humid
iamb86623723iam_b
iambi95512193iambi
iambic12468253iambic
iambs95815053iambs
ibex133813473i_bex
ibis66519563i_bis
ictic9311793ictic
ilex115822033i_lex
ilia46026813i_lia
image81411283image
imago8118683imago
imam81718323i_mam
imams91511103imams
imaum9139633imaum
imbed105013633imbed
imbibe1234683imbibe
imbue939463imbue
imide85716873imide
imidic11358193imidic
imido85812223imido
imids86015123imids
imine75821043imine
imino74315213imino
immane1038873immane
immesh1334103immesh
immixing2043543immixing
immune1035423immune
immure1036023immure
imp76626963i_m_p
impair1035993impair
imped105117973imped
impel95711763impel
imping114315333imping
impish13499173impish
imply124911833imply
imps86221113i_mps
index13310983index
indie63721463indie
inia45024693i_nia
inti46626073inti_
intis55121633intis
iodic84816743iodic
iodid74315523iodid
iodin64419343iodin
ionic74622653ionic
irid55927163i_rid
iris45732543i_ris
ism56322383ism__
isms66213473ism_s
iwis77117003i_wis
ixia115713203i_xia
jimmied19275023jimmied
jimmies18328773jimmies
jimminy2133363jimminy
jimmy19538503jimm_y
kami105823643kami_
kamik105011553kamik
kylix19416323kylix
lamia75324323lamia
limbi96513793limbi_
limbic12528723limbic
limit73126333limit
limmer104314793limmer
limnic10418833limnic
limpid11389743limpid
lummox1733053lummox
maid75537633_maid
mail65543433_mail
maim85831473_maim
main65345503_main
mair66133763_mair
mamie95826003mamie
mammie94313783mammie
max129045443__max
maxi137023553_maxi
mi48249043__mi_
mib76946103__mib
mic77647633__mic
mid67354453__mid
midi75628463midi_
midis85923403midis
mig65646073__mig
mil55752103__mil
milia72719563milia
mim76048413__mim
mime85736393mim_e
mimed105622733mimed
mimeo96018683mimeo
mimer94825763mimer
mimes95732023mimes
mimics1289353mimics
miming114317253miming
mini65634543mini_
minim97321593minim
minis75432983minis
minx137723333_minx
mir57046763__mir
mirex146816623mirex
miri66730363miri_
mirin75023143mirin
mis58162613__mis
mitis75425983mitis
mixt136831913__mixt
mm67826813_mm__
moil65534083_moil
momi87524483momi_
nimbi94910293nimbi_
nimmed11368573nimmed
nimming12358133nimming
nix106932833__nix
ohmic1237833ohmic
omit65337363_omit
osmic939913osmic
pix126437933__pix
pommie123710503pommie
premix173710333premix
radix134414593radix
rami66034093rami_
ramie75027823ramie
refix155212483refix
remex146315793remex
remit75737223remit
remixt155014853remixt
rimmed114812303rimmed
rimmer103516033rimmer
rimming123411063rimming
semi65127223semi_
semis74623533semis
simlin8311723simlin
simmer104115353simmer
six105339743__six
smit65138403_smit
summit10311543summit
tamis76728723tamis
tammie104212683tammie
timid84815713timid
tumid84114023tumid
umami939883umami_
umamis1038273umamis
umm711921263umm__
unfix15429033unfix
unmixt15378703unmixt
varix154313503varix
vomit102622573vomit
yomim12510073yomim
zamia165115213zamia

Search took 5 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 Filter178691836670.1101624463.6
2DLD Change Limit836672324.17020064.0
3Display Results2322320.0633682.5
 (SQL Overall)1786912324.34341144.6
 
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.