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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
ideative123857(None) 
creative132812802creative
dative10311812_d_ative
dilative1239522dilative
idealise938052idealise
idealize1847872idealize
ideate7313682ideat__e
ideating10311702ideating
ideation9310492ideation
illative1147182illative
iterative12410712iterative
sedative1238852sedative
ablative1348243ablative
adaptive1445133adaptive
additive1345863additive
adjective2244813adjective
adoptive1445503adoptive
advective1845233advective
adventive1645813adventive
agentive1248043agentive
amative12311733_amative
bijective2343913bijective
conative131214623conative
creatine103417413creatine
creatives14279693creatives
curative13310403curative
datives11310073_d_atives
dearie73319813_deari_e
deave95022333_dea__ve
deceive1337813_deceive
denotive1238673_denotive
dentine83320243_dentine
deprive1338303_deprive
derive103817043_de_rive
destine83719953_destine
deviative1647723_deviative
digestive1446243digestive
dilutive1255373dilutive
directive1557773directive
donative12139873donative
durative1239073durative
educative15136553educative
eductive1476863eductive
egestive1246833egestive
ejective2037153ejective
elative10312453_elative
elective13311003elective
erective13311833erective
ergative1238973ergative
exertive1839083exertive
federative1746163federative
festive1339773_festive
fixative2145083fixative
idealised1145673idealised
idealises1047783idealises
idealism1147013idealism
idealist9310653idealist
ideality1247153ideality
idealized2046653idealized
idealizer1945473idealizer
idealizes1947393idealizes
ideated9310973ideat_ed
ideates8313733ideat_es
ideations1039903ideations
identic1038043identi_c
identify1544133identify
identity1245373identity
illatives1245523illatives
imitative1446333imitative
impactive1845283impactive
imperative1748563imperative
inactive1348203inactive
incentive1489603incentive
inceptive1677823inceptive
indicative1647713indicative
inductive1547263inductive
indurative1447283indurative
inertiae8411473inertiae
infective17108973infective
ingestive1347393ingestive
injective2178023injective
invasive1444833invasive
invective1798043invective
inventive1588043inventive
irrelative1344783irrelative
isatine7311763i_satine
laxative1845093laxative
ligative1258803ligative
locative1338683locative
mediative1548123mediative
mutative1348283mutative
native9613013__native
negative1239083negative
operative141110553operative
optative1347653optative
orective1339353orective
oxidative2044313oxid_ative
precative16312573precative
putative1348373putative
radiative1348173radiative
reactive13310473_reactive
relative11313143relative
restive10315933_restive
rotative11310343rotative
sanative11310473sanative
sedatives1346153sedatives
siccative1645103siccative
stative102612933_stative
steatite8310583steatite
teatime9310083_teatime
treatise8311103treatise
vibrative1745583vibrative
violative1545113violative
vocative1637913vocative

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621146.36022981.4
3Display Results1141140.0462478.3
 (SQL Overall)1786911146.82926166.5
 
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.