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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

86 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
tiki8762085(None) 
piki106520571piki
tike85534491tike
tikis95615971tikis
tipi69924441tipi
titi47130631titi
bidi78226602bidi
bike106532612bike
bikie113915882bikie
dike95935772dike
hike116830402hike
hili75626642hili
kaki76520922kaki
ki67537972__ki
kike76524802kike
kiwi113211812kiwi
like86040852like
liri45128262liri
midi75628492midi
mike105535302mike
mini65634572mini
miri66730382miri
nidi56524412nidi
nisi45823252nisi
pika106322962pika
pike106335222pike
pikis115116392pikis
pili66130362pili
raki87127832raki
saki85628482saki
sika86021332sika
sike87138792sike
ski74925702_ski
taka87623592taka
take84739262take
takin94921302takin
tali46837162tali
taxi117124762taxi
ti28448302t__i
tibia7312402tibia
tic56343472ti_c
tick106231232tick
ticks115823292ticks
tics65729642tics
tide55237392tide
tidy86822432tidy
tie36557542ti_e
tied55535222tied
tier44936152tier
ties45248322ties
tiff104727732tiff
tikes95628902tikes
tikka835582tikka
til36350272ti_l
tile45451452tile
till45941212till
tils45739622tils
tilt46252432tilt
time66235022time
timid84815732timid
tin36362182ti_n
tine45855142tine
ting56139922ting
tins45251312tins
tint46758872tint
tiny76134642tiny
tip56551232ti_p
tipis76019922tipis
tips66436772tips
tire46143362tire
tirl45029932tirl
tiro46832372tiro
tis37056652ti_s
tit36771062ti_t
titis56023812titis
tits46145052tits
tivy1014516872tivy
toke86738492toke
topi67830392topi
tori47542152tori
trike95320162trike
tsk75814732tsk_
tsks86410662tsks
tui37034022t_ui
tyke115720502tyke
ziti136022382ziti

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.313570897.8
2DLD Change Limit29872860.86034734.9
3Display Results86860.0165375.0
 (SQL Overall)178691861.189150286.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.