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

124 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
intreating1161401(None) 
entreating11811551entreating
estreating11710362estreating
inbreathing1742802inbreathing
increasing1346322increasing
interacting14411712interacting
interesting12411122interesting
intimating13410822intimating
intonating1148632intonating
intrusting11128172intrusting
intubating1376712intubating
iterating10314252i_terating
mistreating1449282mistreating
nitrating10312672nitr_ating
retreating111414772retreating
treating92519612__treating
uncreating13310472uncreating
untreading1247562untreading
antedating1277553antedating
cocreating15310293cocreating
creating113921953__creating
enervating1488433enervating
entreaties1048113entreaties
entreatingly1653033entreatingly
entrusting11126183entrusting
enwreathing1842123enwreathing
filtrating1445973filtr_ating
ideating10311703i__deating
imprecating1844903imprecating
inbreeding14104123inbreeding
incarnating1445543incarnating
incenting12912063in_centing
incepting1489293in_cepting
incrusting13126473incrusting
incubating1597133incubating
incurvating1784953incurvating
indagating1345263indagating
indenting11911263in_denting
indicating1449693indicating
indurating1249243indurating
inebriating1446053inebriating
infecting15109673in_fecting
infesting13109513in_festing
inflating13310443in_flating
inflecting1646313inflecting
infracting1647353infracting
infuriating1546283infuriating
ingesting11129623in_gesting
ingrafting1544893ingrafting
inheriting1448853inheriting
initiating1149623initiating
injecting1997693in_jecting
inletting1087873in_letting
innervating1546363innervating
innovating1444613innovating
inserting10914233in_serting
insetting1079283in_setting
insheathing18102693insheathing
insolating1149153insolating
inspecting1546223inspecting
instating10812213in_stating
instigating1347153instigating
instructing1446293instructing
insulating1139263insulating
integrating1349493integrating
intending1139983int_ending
intenerating1346723intenerating
interabang1344483interabang
intercepting1748873intercepting
interfacing1747703interfacing
interjecting2248393interjecting
interlacing1449053interlacing
interlaying1547573interlaying
interleaving1676163interleaving
intermatting1547173intermatting
interning10315253int_erning
interrelating1457293interrelating
interring10315423int_erring
intersecting1549713intersecting
interweaving1985163interweaving
intestine9411853int_estine
intorting10311413int_orting
intreat7416303intreat___
intreated10312663intreat_ed
intreats8311543intreat__s
intrenching1744073intrenching
intriguing1245103intriguing
introfying1744853introfying
introjecting2254253introjecting
introverting1654273introverting
intruding1146873intr_uding
intuiting1089613int_uiting
intwisting1445063intwisting
inundating1244543inundating
inventing13109973in_venting
inverting131013223in_verting
investing13119393in_vesting
invocating1646333invocating
inweaving1644773in_weaving
laureating1146393laureating
maltreating1455513maltreating
miscreating1648493miscreating
narrating10310353_narrating
outeating10814493out_eating
outrating10916403outr_ating
outreading1239283outreading
overeating141016533overeating
patriating13510203patriating
pretreating1448893pretreating
recreating131214583recreating
retreading12128483retreading
streaking142010323_streaking
streaming12239653_streaming
striating10914193_striating
threating131010053_threating
titrating10310113titr_ating
treading103515333__treading
uncrating12813183uncr_ating
undereating1369553undereating
unresting10311133un_resting
unseating10713203un_seating
unthreading1644153unthreading
untrusting1186003untrusting
unwreathing1842803unwreathing

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 Filter1786911406030.1561145455.1
2DLD Change Limit1406031246.86020496.1
3Display Results1241240.0602066.7
 (SQL Overall)1786911247.07625253.1
 
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.