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

122 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
nisi4582324(None) 
nidi56524401nidi
nisei54214351nisei
ais39083572ais_
animi74016662animi
anis45746462anis_
anise55129702anise
anisic8313792anisic
bidi78226592bidi
bis56860662bis_
bise66437102bise
bisk106523352bisk
cis57748032cis_
cist67244962cist
dis46459892dis_
disc76123232disc
disci85815022disci
dish86328332dish
disk96625832disk
diss56434482diss
fisc96819752fisc
fish106926272fish
fist76248422fist
gist56046762gist
hili75626632hili
his66359502his_
hisn79620932hisn
hiss75629212hiss
hist76551542hist
ins35945602ins_
inti46626082inti
is27048212_is_
ism56322382_ism
jism135514772jism
kis78051482kis_
kiss85227402kiss
kist86540802kist
kiwi113211802kiwi
knish1238602knish
liri45128252liri
lis37162272lis_
lisp68926882lisp
list47055342list
midi75628482midi
mini65634562mini
miri66730372miri
mis58162622mis_
mise66043582mise
miso67229902miso
miss65339422miss
mist66154532mist
naoi46024632naoi
nazi136219872nazi
neist54628442neist
ness45526562ness
nest45548732nest
nevi75116422nevi
nib56745192ni_b
nibs65028312nibs
nice65534712nice
nick106627602nick
nide55535792nide
nigh85220662nigh
nihil8410282nihil
nil36144192ni_l
nill45634302nill
nils46132452nils
nim57142952ni_m
nimbi94910312nimbi
nims66226882nims
nine45842172nine
nip56945982ni_p
nipa69421632nipa
nips65830922nips
niseis63512022niseis
nisus56014392nisus
nit37065942ni_t
nite45943582nite
nitid61817832nitid
nits45741642nits
nix106932832ni_x
nixe115722022nixe
nixie125114942nixie
nixy145714512nixy
nodi56626742nodi
noise55723732noise
noisy86813362noisy
nori47133142nori
nos38859322nos_
nose46739362nose
nosh76223542nosh
nosy76322892nosy
nus37939392nus_
piki106520562piki
pili66130352pili
pis56362032pis_
pish96127912pish
piso66727562piso
piss65033332piss
psi56621622_psi
qis126934382qis_
rise45945232rise
rishi8311252rishi
risk85724102risk
si29149572__si
sis37360542sis_
tiki87620842tiki
tipi69924432tipi
tis37056642tis_
titi47130622titi
vis66747612vis_
visa76323872visa
vise75632672vise
visit8320962visit
wis66552332wis_
wise75737342wise
wish107228732wish
wisp97124072wisp
wiss75630542wiss
wist78049292wist
xis106935332xis_
ziti136022372ziti

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 Filter178691298720.266671770.7
2DLD Change Limit298721220.84035561.9
3Display Results1221220.0333697.0
 (SQL Overall)1786911221.139156884.1
 
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.