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
tiki8762084(None) 
piki106520561piki
tike85534481tike
tikis95615971tikis
tipi69924431tipi
titi47130621titi
bidi78226572bidi
bike106532602bike
bikie113915882bikie
dike95935762dike
hike116830392hike
hili75626632hili
kaki76520912kaki
ki67537952__ki
kike76524782kike
kiwi113211792kiwi
like86040842like
liri45128252liri
midi75628472midi
mike105535292mike
mini65634562mini
miri66730372miri
nidi56524392nidi
nisi45823242nisi
pika106322952pika
pike106335212pike
pikis115116392pikis
pili66130352pili
raki87127832raki
saki85628482saki
sika86021322sika
sike87138782sike
ski74925692_ski
taka87623592taka
take84739262take
takin94921302takin
tali46837162tali
taxi117124762taxi
ti28448292t__i
tibia7312402tibia
tic56343462ti_c
tick106231222tick
ticks115823292ticks
tics65729632tics
tide55237372tide
tidy86822412tidy
tie36557532ti_e
tied55535212tied
tier44936142tier
ties45248312ties
tiff104727722tiff
tikes95628902tikes
tikka835572tikka
til36350262ti_l
tile45451442tile
till45941202till
tils45739612tils
tilt46252422tilt
time66235012time
timid84815732timid
tin36362172ti_n
tine45855132tine
ting56139902ting
tins45251302tins
tint46758862tint
tiny76134632tiny
tip56551222ti_p
tipis76019922tipis
tips66436762tips
tire46143352tire
tirl45029922tirl
tiro46832362tiro
tis37056642ti_s
tit36771052ti_t
titis56023812titis
tits46145042tits
tivy1014516862tivy
toke86738492toke
topi67830392topi
tori47542152tori
trike95320162trike
tsk75814732tsk_
tsks86410662tsks
tui37034022t_ui
tyke115720502tyke
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.296603685.8
2DLD Change Limit29872860.92332364.0
3Display Results86860.0136615.4
 (SQL Overall)178691861.232145041.4
 
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.