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

98 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
inarching154634(None) 
arching136216692__arching
inarming1138342inar_ming
inching134414322in__ching
inearthing1443542inearthing
marching164312192_marching
parching164313052_parching
searching1538342searching
snatching1536362snatching
starching1538592starching
aching126521973__a_ching
anarchic1546853anarchi_c
anarchies1448183anarchies
anarchism1645653anarchism
anarchist1447563anarchist
archine125817053__archine
archings14499863__archings
arcing95819643__arc_ing
arcking145811963__arcking
baching156017753_ba_ching
batching163712093_batching
beaching164114143bea_ching
birching16328463_birching
blanching17297093blanching
branching17289263branching
caching156317503_ca_ching
catching163712773_catching
churching2055083churching
cinching163310223cin__ching
coaching164011963coa_ching
cranching17278733cranching
earthing12310323_earthing
enacting11311363ena_cting
enriching1546153enriching
farcing133514003_farc_ing
farthing1538073_farthing
financing1544073financ_ing
gnarling10217603gnar_ling
gnarring10225973gnar_ring
gnashing1336423gna_shing
hatching173312213_hatching
inarch1139173inarch___
inarched1486113inarch_ed
inarches1358043inarch_es
indicting1339613indicting
inducing1237873induc_ing
inducting1338373inducting
infecting15109673infecting
infracting1647353infracting
ingrowing1445533ingrowing
injecting1997693injecting
inlacing1158373inlac_ing
inmeshing1595333inmeshing
inrushing1365503inrushing
interarching1845013interarching
intrenching1744073intrenching
intruding1146873intruding
inuring81213013inur__ing
inurning937553inur_ning
itching134011683i__tching
knacking14296713kna_cking
latching143712023_latching
leaching143012833lea_ching
lurching14277333_lurching
matching163512393_matching
naething1236073_naething
narcein936293_narcein_
narceine1046753_narceine
narceins1036413_narceins
narking124015383_nar_king
niching133612433_n_iching
northing12199063_northing
notching14288583_notching
patching163212753_patching
peaching163613643pea_ching
perching163711633_perching
pinching163711053pin__ching
poaching163510833poa_ching
ranching141712043_ranching
reaching143317203rea_ching
roaching143210433roa_ching
scarphing1735243scarphing
scorching1735633scorching
smirching1744393smirching
snacking153411703sna_cking
snarfing12358663snar_fing
snaring83920953snar__ing
snarling92513183snar_ling
snitching1535913snitching
stanching1538083stanching
teaching143612603tea_ching
thatching1835143thatching
torching142510083_torching
unarming1138623unar_ming
unearthing1454373unearthing
unlatching1643153unlatching
watching173011173_watching
winching17359903win__ching

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 Filter1786911486410.420425454.8
2DLD Change Limit148641987.37620152.0
3Display Results98980.0462130.4
 (SQL Overall)178691987.84222786.4
 
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.