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

53 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
schillings1624327(None) 
schilling15286391schilling_
shillings13348091s_hillings
chilling143512182_chilling_
chitlings15255902_chitlings
schoolings1644012schoolings
shielings13237122s_hielings
shilling123315382s_hilling_
skillings14246132s_killings
billings113412633__billings
callings113613833_c_allings
ceilings11397993_cei_lings
childing15288503_childing_
chillies134113483_chilli_es
chilliness1555313_chilliness
chillingly1943373_chillingly
chillis124411603_chilli__s
chitling142910663_chitling_
chitlins13289393_chitlin_s
drillings11285823_drillings
fillings122910503__fillings
frillings13265803_frillings
hildings13347503__hildings
hilling113821773__hilling_
killings133710483__killings
millings113712583__millings
quillings19225743_quillings
sailings93513253s_ai_lings
scantlings1393313scantlings
schillers14285663schill_ers
schooling1546943schooling_
scoldings13224133sc_oldings
scrolling12187803scrolling_
sculling112910993sc_ulling_
shealings13317563s_healings
shelling123515213s_helling_
shelvings16283823s_helvings
shieling123512403s_hieling_
shilingi1233843s_hi_lingi
shippings17275683s_hippings
shirrings13245323s_hirrings
shirtings13276603s_hirtings
shrilling13307693shrilling_
siblings11108123s__iblings
skilling132911333s_killing_
spellings12296553s_pellings
spilings11308813s_pi_lings
spilling113113943s_pilling_
stilling93415323s_tilling_
striplings1344183striplings
swellings13296103s_wellings
swilling123511933s_willing_
twillings13234913_twillings

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.796224486.2
2DLD Change Limit140603536.78020737.9
3Display Results53530.0163312.5
 (SQL Overall)178691537.59223536.7
 
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.