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 “mitis” with Change Limit: [1] [2]

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

154 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
mitis7542599(None) 
metis75025901metis
midis85923411midis
minis75432991minis
mites75141801mites
mitts75523751mitts
titis56023811titis
zitis145815581zitis
aits46355532ait_s
amities9317382amities
antis55033312antis
bidis86721142bidis
bites75641172bites
bits66148162bit_s
bitts75022592bitts
cites74435592cites
cities84524852cities
cutis77723762cutis
ditas65923672ditas
dites66339152dites
dits56450522dit_s
emits75421472emit_s
finis86824262finis
fits76043462fit_s
gites65630182gites
gits55744592git_s
hits75545132hit_s
ibis66519582_ibis
impis96213852impis
intis55121642intis
iris45732552_iris
iritis63113732iritis
its35538832_it_s
iwis77117012_iwis
kites95432542kites
kiths125814972kiths
kits86441772kit_s
kiwis12328582kiwis
litas54923772litas
lits46252492lit_s
mantis83926032mantis
mates75251362mates
maths105624022maths
matin75132852matin
matins84527782matins
mats65460292mat_s
matts76829182matts
mavis105622722mavis
maxis145721562maxis
metes74736212metes
meths105320232meths
mibs85330482mi_bs
micas96823052micas
micks135525372micks
mics87435152mi_cs
midi75628482midi_
mids76541792mi_ds
miens76118302miens
miffs134512882miffs
miggs96311372miggs
migs76935322mi_gs
mikes115129892mikes
milds86422052milds
miles74645072miles
milia72719572milia
milks115020582milks
mills75435052mills
milos75428012milos
mils66045332mi_ls
milts75430712milts
mimes95732022mimes
mimic111414322mimic
mimics1289362mimics
minas75434112minas
minds85427122minds
mines75651952mines
mini65634562mini_
minim97321602minim
minims104514812minims
minish115216302minish
minks115829272minks
mints76834042mints
minus75223932minus
miosis83615162miosis
miotic103715752miotic
miotics112710652miotics
mips85534082mi_ps
mires75640882mires
miri66730372miri_
mirin75023152mirin
mirins83918902mirins
mirks115122142mirks
mirs66940572mi_rs
mirths114912992mirths
mis58162622m__is
mises74740562mises
misos76523292misos
miss65339422mi_ss
missis84417502missis
mists76633902mists
mite66249412mit_e
miter75734792miter
miters84328782miters
mitier83620672mitier
mitiest93520052mitiest
mitises9315542mitises
mitosis939632mitosis
mitre75522422mitre
mitres83922072mitres
mitt66145492mit_t
mity95528212mit_y
mixes147224402mixes
motes75944002motes
moths106021552moths
motif10519682motif
motifs1139672motifs
mots66853162mot_s
motts76527002motts
muftis1158052muftis
munis75022002munis
mutes75033782mutes
mutism103211462mutism
muts64839982mut_s
mutts75120252mutts
myths135911602myths
nites55736342nites
nitid61817832nitid
nits45741642nit_s
omits75018262omit_s
otitis63612342otitis
pikis115116392pikis
pilis75825202pilis
pitas77427672pitas
piths105817542piths
pities83828082pities
pits66348742pit_s
rites54442552rites
rotis56327062rotis
satis55633682satis
sites56045432sites
sits45050202sit_s
situs55019232situs
smites83921922smites
smiths114711022smiths
tikis95615972tikis
tipis76019922tipis
tis37056642__tis
titi47130622titi_
tits46145042tit_s
wites85536962wites
wits76044872wit_s
yetis85418392yetis
ziti136022372ziti_
zits136030292zit_s

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001541.58034050.6
3Display Results1541540.0463347.8
 (SQL Overall)1786911541.93992156.3
 
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.