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

100 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
invade10157851invade_
invaded12127041invaded
invader11146451invader
invades11118291invades
invaders12105302invaders
anadem939183an_adem
cadet85339343__cadet
evade938183_evade_
evaded1137063_evaded
evader1036813_evader
evades1039023_evades
imaret81121233i_maret
inane52820343in_ane_
inaner62213543in_aner
inanes62519803in_anes
inanest72115363in_anest
inapt73522693in_a_pt
incage93513623incage_
incaged114010443incaged
incages103013883incages
incant82418513inca_nt
incase83615283incase_
incased103612393incased
incases93615973incases
incident11410203incident
incudes10319523incudes
indent73021243in__dent
index13310983in__dex
infant92315133infa_nt
infante101910883infante
infarct1249013infarct
infare9313083infare_
infares10313023infares
infidel1146043infidel
ingate73018243ingate_
ingates82716913ingates
inhabit1277403inhabit
inhale9411513inhale_
inhaled1169333inhaled
inhaler1068053inhaler
inhales10511863inhales
inkjet1737453in_kjet
inlace82513043inlace_
inlaced10239873inlaced
inlaces92512903inlaces
inlander937223inlander
inlayer1036933inlayer
inlet53732403in__let
inmate82917363inmate_
inmates92715783inmates
innage73011573innage_
innages82911303innages
innate63917313innate_
inquiet16311413inquiet
insane6314893insane_
insaner7310443insaner
insanest8410343insanest
inset54430863in__set
inside7613453inside_
insider849733insider
insides8512653insides
intact8314663inta_ct
intake10510863intake_
intakes11310943intakes
intranet8418443intranet
invading1336263invading
invalid1146393invalid
invalided1444023invalided
invar839513inva__r
invars9310003inva_rs
invent93316363inv_ent
invert94120083inv_ert
invest93014843inv_est
invite93715033invite_
invited113612463invited
invitee103713543invitee
inviter104112313inviter
invites103915813invites
invoke1336213invoke_
invoked1535303invoked
invoker1435363invoker
invokes1436383invokes
irade65618153i_rade_
irades74517393i_rades
kneaded13146473kneaded
kneader1275893kneader
minaret9520683min_aret
reinvade1244503reinvade_
reinvaded1444073reinvaded
reinvades1344643reinvades
unadept1046603un_adept
unevaded1336423unevaded
unfaded123111733unfaded
unjaded16279143unjaded
unlade72714153unlade_
unladed92614373unladed
unladen8248653unladen
unlades82612833unlades
unmade92911063unmade_
valet84337873__valet

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271005.76623244.4
3Display Results1001000.0303333.3
 (SQL Overall)1786911006.20228811.8
 
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.