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

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
nide55535781nide
nidi56524391nidi
aid49269072aid_
aide56044992aide
aids57846352aids
bid67751792bid_
bide76041482bide
bidi78226572bidi
bids75838432bids
cnida878952cnida
did56850512did_
dido66528192dido
didy99121502didy
eide55832232eide
fid76847682fid_
fido87726392fido
fids87034732fids
gid57047262gid_
gids65933732gids
hadj155818672hadj
hid76248362hid_
hide85134622hide
id38941832_id_
ids47535462_ids
kid86540612kid_
kids96029632kids
lid47453512lid_
lido56028152lido
lids56336452lids
mid67354462mid_
midi75628472midi
mids76541782mids
nada58022902nada
nib56745192ni_b
nibs65028312nibs
nice65534712nice
nick106627602nick
nidal65217102nidal
nided75920872nided
nides65229132nides
nidus65913572nidus
nigh85220662nigh
nil36144192ni_l
nill45634302nill
nils46132452nils
nim57142952ni_m
nims66226882nims
nine45842172nine
ninja1258092ninja
nip56945982ni_p
nipa69421632nipa
nips65830922nips
nisi45823242nisi
nit37065942ni_t
nite45943582nite
nits45741642nits
nix106932832ni_x
nixe115722022nixe
nixy145714512nixy
nod47549562nod_
node513036882node
nodi56626742nodi
nods55838222nods
nude56626272nude
rid46754622rid_
ride55945122ride
rids56539542rids
side55444482side
sidh86222982sidh
snide64318722snide
tide55237372tide
tidy86822412tidy
vid77241802vid_
vide85432752vide
vids85627532vids
wide85235402wide
yid76640822yid_
yids85224952yids

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.0762351197.4
2DLD Change Limit29872781.00029872.0
3Display Results78780.0164875.0
 (SQL Overall)178691781.092163636.4
 
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.