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

49 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
schoolings164401(None) 
schooling1546941schooling_
schillings16243272schillings
schoolbags1852142schoolbags
shooling123012562s_hooling_
shootings13266062s_hootings
spoolings12245392s_poolings
chitlings15255903_chitlings
cholines132214493_ch_olines
choosing142010133_choosing_
chromings17286093_chromings
codlings123110103_c_odlings
cookings15358603_c_ookings
cooling103422573_c_ooling_
cowlings14359783_c_owlings
reschooling1743203reschooling_
scantlings1393313scantlings
schilling15286393schilling_
schmoosing1843143schmoosing_
schmoozing2742723schmoozing_
scholiums1644843sch_oliums
schoolbag1752023schoolbag_
schoolboys2052173schoolboys
schoolgirls1751853schoolgirls
schoolkids2062313schoolkids
schools1249113school___s
schooltimes1852603schooltimes
scoldings13224133sc_oldings
scooping133610633sc_ooping_
scooting113012643sc_ooting_
scourings12235293sc_ourings
scoutings12306143sc_outings
scowling1458293sc_owling_
scrolling12187803scrolling_
scrooping1446593scrooping_
shealings13317563s_healings
shielings13237123s_hielings
shillings13348093s_hillings
shoaling123111753s_hoaling_
shooing112112913s_hoo_ing_
shooting122812863s_hooting_
shoppings17295073s_hoppings
shorings12269483s_h_orings
showings15246883s_h_owings
showrings1644063s_howrings
snooling93013473s_nooling_
spooling113212563s_pooling_
stooling93113133s_tooling_
toolings9248473__toolings

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 Filter1786911406030.406440125.6
2DLD Change Limit140603498.53016483.4
3Display Results49490.0331484.8
 (SQL Overall)178691498.96919923.2
 
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.