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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

78 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
dikdik115261(None) 
dikdiks1242561dikdiks
didie74120572di_die
aikido1135483aikido
bidi78226603bi_di_
bidis86721153bi_dis
bikie113915883bik_ie
bindi85617023bindi_
bindis94614583bindis
birdie94013783birdie
dakoit11310353dakoit
diacid10310633diacid
diadem1037583diadem
diamin9312523diamin
diapir9357113diapir
diazin1639163diazin
dibbuk1543503dibbuk
dick116432393di__ck
dickie133913113dickie
did56850533di_d__
diddle94915213diddle
diddly12389573diddly
didies84621833di_dies
dido66528213di_d_o
didos76820823di_dos
didst74619623di_dst
didy99121523di_d_y
died66137863died__
diesis74013493diesis
digit73825273di_git
dike95935773dik__e
diked115024683dik_ed
diker105524553dik_er
dikers114418793dikers
dikes105831333dik_es
dikey135116423dik_ey
diking124320243diking
diktat11310693diktat
dildo71911783dild_o
dildoe8198673dildoe
dildos8179303dildos
dimwit1237953dimwit
dindle84417223dindle
dink97137813di__nk
diode74716123diod_e
diodes83915783diodes
dioxid1568393dioxid
dioxin14118783dioxin
dipodic1397593dipodic
dirdum1036033dirdum
dirk96326843di__rk
disci85815023disci_
disdain938513disdain
disk96625843di__sk
disklike12206743disklike
dislike122913453dislike
distil73616433distil
divide113410893divide
dixit134420593di_xit
duddie9348863duddie
dyadic1336093dyadic
indie63721473_indie
iodic84816753_iodic
iodid74315533_iodid
iodin64419353_iodin
kiddie12359403kiddie
klik74412663__klik
midi75628493mi_di_
midis85923423mi_dis
misdid10510573misdid
nidi56524413ni_di_
oidia6314963oi_dia
piki106520573pik_i_
pikis115116393pik_is
tiki87620853tik_i_
tikis95615973tik_is
widdie113410733widdie
zaddik2134243zaddik

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 Limit112716785.28021347.7
3Display Results78780.0332363.6
 (SQL Overall)178691785.70331332.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.