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

72 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
prechill154619(None) 
prechills1645121prechills
preachily1945142preachily
prebill1138802pre_bill
prechilled1843892prechilled
predrill1145932predrill
prepill1147582pre_pill
archil11611573ar_chi_l
archils12510533ar_chils
brachial15219303brachial
breccial1444693breccial
chill105619873___chill
erectile1039513erectile
erewhile1473673erewhile
freewill1443413freewill
orchil1158653or_chi_l
orchils1277703or_chils
overchill1794213overchill
parochial1646183parochial
patchily1885813patchily
peching154513903p_eching
perching163711633perching
petechial1644093petechial
pitchily1855013pitchily
preachier1646923preachier
preachify2243053preachify
preaching172811163preaching
preaxial1746973preaxial
prebills1237293pre_bills
preboil1148953preboi_l
preboils1267293preboils
prebuild1344303prebuild
prebuilt1247033prebuilt
precaval1544723precaval
precheck2144153precheck
prechilling1943743prechilling
prechose15129773prechose
precipe133012123prec_ipe
precis103416703prec_i_s
precise113518173prec_ise
precocial1547503precocial
precoital1347273precoital
precool1139013prec_ool
precools1237703precools
predial103815413pre_dial
predrills1244473predrills
prefile123413183pre_file
preppily1444593preppily
preschool1643933preschool
presell939303pre_sell
preship1439793preshi_p
preships1539313preships
pretell938243pre_tell
pretrial10511983pretrial
prettily1337283prettily
prevail1238243prevai_l
prevails1337663prevails
pricily142710283pric_ily
prill74117943pr___ill
punchily1844863punchily
rachial122012173_rachial
rachilla1345713_rachilla
rebill84713253_re_bill
recall83815723_rec_all
recoil84016723_recoi_l
recoils93814873_recoils
redrill857893_redrill
refill94514053_re_fill
techily1537123_techily
trochil1258713trochi_l
trochili1376943trochili
trochils1388583trochils

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 Filter1786911461620.420425454.8
2DLD Change Limit146162727.83018666.9
3Display Results72720.0302400.0
 (SQL Overall)178691728.28021581.0
 
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.