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

78 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
overarch164724(None) 
hierarch1644042hierarch
overact12315042overa_ct
overarched1946092overarched
overarches1846832overarches
overarm12239792overar_m
overarms13258382overarms
overmatch1944242overmatch
overmuch1844082overmuch
overrash1436952overrash
overrich1648452overrich
overwatch2043832overwatch
xerarch1943842_xerarch
eparch13258423__eparch
exarch18196173__exarch
hierarchs1743423hierarchs
hierarchy2052733hierarchy
interarch1446723interarch
mesarch1445533_mesarch
oligarch1443083oligarch
omniarch1562723omniarch
orach105219233o__ra_ch
outmarch1544783outmarch
overable13513573overable
overacts1339653overacts
overage11514053overa_ge
overaged13511673overaged
overages12513833overages
overall10411083overa_ll
overalls11410393overalls
overapt12312653overa_pt
overarching2056893overarching
overarmed1538103overarmed
overate10620963overa_te
overawe13511463overa_we
overawed1579973overawed
overawes14511183overawes
overbred1459853overbred
overcoach1944793overcoach
overcram1537073overcram
overcrop1545773overcrop
overdare12311183overdar_e
overdared1439163overdared
overdares13310673overdares
overdeck1835223overdeck
overdraw1535803overdraw
overdrew1536233overdrew
overdry1435903overdr_y
overfar13227943overfar__
overfish1737893overfish
overfree1439003overfree
overgrew1535823overgrew
overgrow1544833overgrow
overhard15238793overhar_d
overhigh1846363overhigh
overlarge1346823overlarge
overlush1445273overlush
overnice13310093overnice
overpack1966623overpack
overprice16108893overprice
overran10311663over_ran
overrank1548113overrank
overrate11615693overrate
overreach1745503overreach
overrun1038023over_run
oversauce1447043oversauce
oversick1736983oversick
overtart11312493overtar_t
overteach1745003overteach
overtrick1865833overtrick
overtrim1337483overtrim
overurge1277103overurge
overwarm16236933overwar_m
overwarms17225693overwarms
overwary17197413overwar_y
search113312423_se_arch
tetrarch13104783tetrarch
trierarch1452703trierarch

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.420425454.8
2DLD Change Limit146162787.25020160.3
3Display Results78780.0332363.6
 (SQL Overall)178691787.70323197.6
 
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.