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 “schillers” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

128 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
schillers1428566(None) 
chillers133710921_chillers
schiller13296471schiller_
achilleas1443262achilleas
chiller124112182_chiller_
hillers103718732__hillers
scullers103510482sc_ullers
shellers112812572s_hellers
sillers73822102s__illers
spillers103311702s_pillers
swillers11299112s_willers
achievers1743433achievers
achillea1344103achille_a
billers94720833__billers
braillers1135553braillers
callers94221963_c_allers
cavillers1435613cavillers
ceilers93912533_cei_lers
chicles143512503_chicle_s
chiders135312943_chi_ders
chiggers1535563_chiggers
childes134211273_childe_s
childless1543813_childless
chiles115425303_chi_le_s
chilies124218303_chilie_s
chilled133310933_chille_d
chillest13259593_chillest
chillier13328423_chillier_
chillies134113483_chillies
chillis124411603_chill_is
chillness1455373_chillness
chills114717703_chill__s
chillums1544163_chillums
chimers144515143_chi_mers
chimleys1883633_chimleys
chinless1337493_chinless
chippers173510883_chippers
chirpers15358133_chirpers
chiselers1445453_chiselers
chisellers1543083_chisellers
chitters133711173_chitters
cholers124215203_ch_olers
coilers93619903_coi_lers
crullers1047303_crullers
cullers93418853_c_ullers
drillers9429723_drillers
echelles1346673echelle_s
fillers104320213__fillers
frillers11349873_frillers
gillers84216903__gillers
grillers93810813_grillers
hellers103619833__hellers
hiller94421633__hiller_
hollers103818233__hollers
hullers103616263__hullers
killers114215583__killers
millers93621343__millers
philters1398173_philters
sailers73822323s_ai_lers
sailless82410373s_ailless
scalers93817263sc__alers
scalpers123710863sc_alpers
schedulers1662083schedulers
schemers1576703sch_emers
schilling15286393schilling
schillings16243273schillings
schizier2234063schizier_
schleps1445483sch__leps
schliere1343843sch_liere
schmeers1574833sch_meers
scholars1336683sch_olars
schooners1445663schooners
schussers1442553schussers
scillas9310473sc_ill_as
scolders11288993sc_olders
scowlers13257353sc_owlers
scrawlers1434743scrawlers
scribblers16183103scribblers
scribers12307953scri_bers
scrimpers1554633scrimpers
scripters13116673scripters
scufflers17285033scufflers
sculkers14306933sc_ulkers
sculler99812153sc_uller_
scullery13296333sc_ullery
sellers73721313s__ellers
sheller103515883s_heller_
shelters113412813s_helters
shelvers14388813s_helvers
shickers173012823s_hickers
shielders1334763s_hielders
shiers94921753s_hi__ers
shifters14319863s_hifters
shikkers14326523s_hikkers
shilled113313623s_hille_d
shills94519613s_hill__s
shimmers15269413s_himmers
shiners104015943s_hi_ners
shinglers13246443s_hinglers
shipless13277693s_hipless
shippers153012313s_hippers
shirkers15319583s_hirkers
shitless11249243s_hitless
shivers133714833s_hi_vers
shriller1136823shriller_
sidlers83414233s__idlers
siller64026063s__iller_
silvers104714043s__ilvers
skilless12246763s_killess
skillets12226823s_killets
smellers10329763s_mellers
smilers94113853s_mi_lers
soilless8279033s_oilless
spallers102910733s_pallers
spellers102812753s_pellers
spielers10319653s_pielers
spiller92914333s_piller_
spoilers10238633spoi_lers
squallers1834683squallers
stiflers11238833s_tiflers
stiller73414293s_tiller_
strollers937543strollers
swiller103211663s_willer_
thrillers1244473thrillers
tillers73418743__tillers
trillers83613493_trillers
whirlers14286053_whirlers
willers103517913__willers

Search took 7 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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411286.36023371.2
3Display Results1281280.0632031.7
 (SQL Overall)1786911286.57927160.8
 
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.