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

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

74 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
didie7412056(None) 
didies84621831didies
aide56044992aid_e
bide76041472bid_e
bidi78226562bidi_
bidis86721142bidis
bikie113915882bikie
birdie94013782birdie
civie103716352civie
dexie134716892dexie
dice75841892di_ce
dicier94416232dicier
dickie133913112dickie
did56850512did__
diddle94915212diddle
dido66528192did_o
didoes85716962didoes
didos76820812didos
didst74619612didst
didy99121502did_y
die46759652__die
diene65720132diene
digit73825272digit
dikdik1152612dikdik
dike95935762di_ke
dildoe8198672dildoe
dime76237642di_me
dindle84417222dindle
dine55555332di_ne
dinge75627302dinge
diode74716112diode
dire56644142di_re
dirge75117072dirge
disme85716242disme
dite55547552di_te
dive85634772di_ve
divide113410892divide
divine103514462divine
dixit134420592dixit
dobie84920322dobie
dodge86618122dodge
dogie75222792dogie
dowie94721142dowie
doxie136017152doxie
duddie9348862duddie
dude65629662dud_e
eide55832232eid_e
fidge104516052fidge
hide85134622hid_e
idle55423762_idle
indie63721462indie
kiddie12359392kiddie
midge95016542midge
midi75628462midi_
midis85923402midis
nide55535782nid_e
nidi56524392nidi_
nixie125114942nixie
nudie65118672nudie
oidia6314952oidia
oldie6415472oldie
pixie145415522pixie
ride55945122rid_e
ridge75018662ridge
side55444482sid_e
sidhe95315102sidhe
sidle65124032sidle
tide55237372tid_e
tidied83613272tidied
tidier73515112tidier
tidies74721832tidies
vide85432752vid_e
widdie113410732widdie
wide85235402wid_e

Search took 4 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 Filter178691538000.190940478.9
2DLD Change Limit53800743.15617046.9
3Display Results74740.0135692.3
 (SQL Overall)178691743.35953197.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.