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

139 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
increate1031220(None) 
increase1066451increase
uncreate10311351uncreate
cocreate122611812cocreate
create85126382__create
inbreathe1443612inbreathe
incarnate1157222incarnate
inchoate1347672inchoate
increased1245532increased
increaser1154572increaser
increases1157382increases
incubate1238662incubate
incudate1138872incudate
incurvate1446052incurvate
ingrate8715122ingr_ate
intreat7416302intreat_
intreated10312662intreated
intreats8311542intreats
miscreate1348892miscreate
ocreate93711742_ocreate
recreate10313602recreate
uncrate9415952uncr_ate
uncreated12312302uncreated
uncreates11310432uncreates
accrete1137843accre_te
acerate92818913_acerate
acreage1037843_acreage
aureate72515283_aureate
binucleate14113213binucleate
cerate84829463__cerate
cocreated142710093cocreated
cocreates132611883cocreates
concrete12411083concre_te
crate76537403__cr_ate
crease85519573__crease
created104323453__created
creates95225203__creates
cremate113816183__cremate
crenate93317113__crenate
decrease1136563decrease
discrete11410283discre_te
enervate1148453enervate
entreat7315263entreat_
entreated10310973entreated
entreats839773entreats
entreaty1146173entreaty
enucleate1145813enucleate
enwreathe1552863enwreathe
excrete1667163excre_te
ideate7313683i__deate
imprecate1545533imprecate
inbreathed1642783inbreathed
inbreathes1543483inbreathes
incage93513623inc__age
incarcerate1553653incarcerate
incarnated1355813incarnated
incarnates1246713incarnates
incase83615283inc__ase
incense92410303inc_ense
incent83320723inc_ent_
incented112412543inc_ented
incenter102212093inc_enter
incents92414533inc_ents
incept102712753inc_ept_
incepted13177773inc_epted
incepts11238283inc_epts
incest82918743inc_est_
incests92711383inc_ests
incinerate1246463incinerate
incite83618733inc__ite
increasers1243313increasers
incrust949203incrust_
incrusted12125843incrusted
incrusts1036253incrusts
incubated1446983incubated
incubates1347603incubates
inculcate1347433inculcate
inculpate1346793inculpate
incurvated1645103incurvated
incurvates1545733incurvates
indagate1047193indagate
indicate11313353indicate
indurate9311873indurate
inebriate1146633inebriate
inflate10312313in_flate
infuriate1247643infuriate
ingate73018243in__gate
ingrates9514173ingr_ates
initiate8412693initiate
inmate82917363in__mate
innate63917313in__nate
innervate1246593innervate
innovate1145643innovate
inoculate1149623inoculate
insheath14114423insheath
insheathe15163883insheathe
insolate8311893insolate
instate71616483in_state
insulate8312843insulate
interage9314483interage
intimate101013833intimate
intonate8310923intonate
intricate11411193intricate
intubate1047533intubate
inundate946043inundate
inurbane1045243inurbane
invocate1347833invocate
inweave1344723in_weave
irate55627983i__r_ate
iterate71119113iter_ate
lacerate102214703lacerate
laureate888023laureate
lineate7815153lin__eate
linoleate944733linoleate
macerate122314073macerate
miscreated1547423miscreated
miscreates1448103miscreates
narrate7313493_narrate
nervate1039523_nervate
nictate9310223nic_tate
nitrate72017013nitr_ate
nucleate1048673nucleate
ocreae83310273_ocrea_e
picrate112014143picr_ate
procreate1348133procreate
recrate92621663recr_ate
recreated12412533recreated
recreates11313363recreates
secrete9311073secre_te
ulcerate1039733ulcerate
uncinate10312393uncinate
uncrated11416313uncr_ated
uncrates10314563uncr_ates
uncreative1547533uncreative
underate9918603underate
unornate848013unornate
untreated10312903untreated
unwreathe1564423unwreathe
zincate1838533zinc__ate

Search took 8 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.406440125.6
2DLD Change Limit1461621396.87621256.8
3Display Results1391390.0632206.3
 (SQL Overall)1786911397.34524328.3
 
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.