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 “somersaulting” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

60 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
somersaulting166114(None) 
summersaulting197812summersaulting
oversalting1548573_oversa_lting
somersault1252593somersault___
somersaulted1581183somersault_ed
somersaults1351393somersault__s
somerseting1453063somers__eting
somersetting1552183somers_etting
overhauling1846034_overhaul_ing
oversaucing1746264_oversau_cing
assaulting1142925___assaulting
caterwauling1851705caterwaul_ing
compensating1955005compensa__ting
consulting1349085co__ns_ulting
defaulting1543395__de_faulting
desalting1138845__de_sa_lting
footfaulting195735fo_otfaulting
moderating1448805moder_a__ting
numerating1357235numer_a__ting
operating12313725_oper_a__ting
overacting16310915_over_a_cting
overcalling1747325_overca_lling
overcasting1748515_overca_sting
overcounting1846615_overcounting
overcutting1746825_over_cutting
overeating141016535_overea__ting
overhating17910955_overha__ting
overhunting1856525_over_hunting
overmelting1768115_over_melting
overrating14814205_overra__ting
overruling1467615_over_rul_ing
oversaturating1864045_oversaturating
oversaving1738165_oversa__ving
overselling1547795_overs_elling
oversetting1548815_overs_etting
overshooting1944605_overshooting
overslaughing2152085_overslaughing
overspilling1844535_overspilling
overstating15410735_overs_tating
overstudying2043175_overstudying
overstuffing2253055_overstuffing
oversudsing1645015_overs_udsing
oversupping1945215_overs_upping
overtalking1976695_overta_lking
overvaluing1845285_overva_luing
resaluting1137395__re_saluting
resulting10311085__re_s_ulting
sensating1039255s__ensa__ting
seriating10916405s__eria__ting
serrating10513205s__erra__ting
smelting11339715s_me____lting
somnambulating2191525somnambulating
summersault1592205summersault___
summersaulted188965summersault_ed
summersaults16101355summersault__s
summersetting1861285summers_etting
superovulating2092355superovulating
supersaturating1882735supersaturating
superselling1554495supers_elling
tolerating1148595toler_a__ting

Search took 9 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 Filter1786911247900.1401276364.3
2DLD Change Limit124790608.61014493.6
3Display Results60600.0302000.0
 (SQL Overall)178691608.78020352.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.