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

71 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
patriating1351020(None) 
expatriating2253062expatriating
lariating10311792la_riating
palliating1347892palliating
patinating1339882patinating
repatriating1545452repatriating
satiating10311812sat_iating
striating10914192_striating
variating13310952va_riating
aerating92821003_aer_ating
astricting1357833astricting
attriting1048683attri_ting
attritting1144763attritting
aviating12311023_a_viating
castrating1349773castr_ating
catenating1348683catenating
elutriating1245073elutriating
entreating11811553entreating
estreating11710363estreating
expatiating2144363expat_iating
extricating2146693extricating
fabricating1945033fabricating
intreating11614013intreating
laureating1146393laureating
maltreating1455513maltreating
marinating13410273ma_rinating
maturating13108573maturating
metricating1647363metricating
narrating10310353na_rrating
nitrating10312673nitr_ating
outrating10916403outr_ating
paginating1447533paginating
painting113614423pa__inting
palpating1438543pa_lpating
palpitating1644653palpitating
parading12313863pa_r_ading
parawing14310583pa_r_awing
parbaking1877203pa_rbaking
parenting12611583pa_renting
pargeting1338283pa_rgeting
parlaying1537303pa_rlaying
parroting1239153pa_rroting
partaking1698673pa_rtaking
parting103527383pa_r__ting
passivating1743783passivating
patenting1248943pat_enting
patining11312303pat_i_ning
patriate10311933patriat__e
patriated1238533patriat_ed
patriates11311363patriat_es
patriliny1446063patri_liny
patriotic13107583patrioti_c
patriotism1454203patriotism
patristic1389283patristi_c
patristics14105783patristics
patrolling1345693patrolling
patting103722343pat___ting
petrifying1945823petrifying
pirating11314513p_ir_ating
prating103424453p__r_ating
pretreating1448893pretreating
printing113216083p__rinting
prorating12314283pror_ating
radiating111112133ra_diating
retreating111414773retreating
saturating11119203saturating
seriating10916403_seriating
titrating10310113titr_ating
treating92519613__treating
triaging102610543__triaging
vitiating1338413vit_iating

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.403443402.0
2DLD Change Limit140603717.14319684.0
3Display Results71710.0302366.7
 (SQL Overall)178691717.57623586.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.