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

106 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
mikvot155676(None) 
mikvos1554021mikvos
mikvoth1962141mikvoth
divot95723072di_vot
mikron12318502mikron
mikvah18143472mikvah
mikveh18132542mikveh
pivot106523872pi_vot
beknot1239763beknot
bigot84828323bi_got
civet105828733ci_vet
dicot85429093di_cot
diglot83014333diglot
diktat11310693diktat
divots104712203di_vots
eikon939463eik_on
gavot9321123_gavot
giglot84013133giglot
gigot74023073gi_got
idiot6718863_idiot
ikat87626643_ik_at
ikon85814953_ik_on
ingot61221063_ingot
inkpot1237813inkpot
knot85630503__knot
likest104914383likest
lirot5430033li_rot
maggot10311713maggot
magot8326393m_agot
maillot9312173maillot
mako105622363mak_o_
makos116518363mak_os
marmot10318743marmot
mascot104016073mascot
matzot17710983matzot
merlot83217603merlot
miaou7513083mi_aou
miaow1058353mi_aow
micro94715993micro_
micron103714283micron
micros104115363micros
midget103718453midget
midgut103510053midgut
midmost1246153midmost
midst85922553mi_dst
might113827083mi_ght
mignon937953mignon
mikado1344513mikado
mikados1444683mikados
mike105535293mik__e
miked125020453mik_ed
mikes115129893mik_es
miking134218463miking
mikra114610313mik_ra
mikrons13428413mikrons
mikvahs19162493mikvahs
mikvehs19111683mikvehs
milksop1542833milksop
milkwort1745493milkwort
millet84030743millet
milo65536103mi_lo_
milos75428013mi_los
milt65455813mi__lt
mimeo96018683mimeo_
mimeos104511543mimeos
minion83416243minion
minnow1135583minnow
minor74920063mi_nor
mint66758063mi__nt
minuet82621033minuet
mirkest13309723mirkest
mirror848003mirror
misact10316693misact
miscut10614823miscut
misdo85413183misdo_
miseat82925713miseat
misfit112813833misfit
mishit112618203mishit
miskept1538923miskept
misknow1643213misknow
mislit83019693mislit
mismet103722373mismet
miso67229903mi_so_
misos76523293mi_sos
misset85028153misset
missort9314653missort
missout9412663missout
mist66154533mi__st
mitsvoth1641693mitsvoth
mitt66145493mi__tt
mitzvoth2551413mitzvoth
mixt136831923mi__xt
moot67653623m__oot
mot57279423m___ot
motmot10311073motmot
omikron1353173omikron
picot95031013pi_cot
pilot77435063pi_lot
pinot78737293pi_not
pivots115111903pi_vots
reknot10311733reknot
riot45947213ri__ot
rivet85636363ri_vet
sukkot936643sukkot
tinpot8312513tinpot
unknot1037413unknot

Search took 6 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.390458182.1
2DLD Change Limit1127161065.19021717.9
3Display Results1061060.0303533.3
 (SQL Overall)1786911065.61031852.2
 
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.