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

91 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
preloading144658(None) 
reloading1189881_reloading
freeloading1642852freeloading
preboarding1744272preboarding
precoding15109732preco_ding
prefading16149032pre_fading
prelocating1647412prelocating
preluding1337052prel_uding
premolding1644672premolding
presoaking1736252presoaking
reloaning10710482_reloaning
breading123515463bre__ading
deleading1237773_deleading
dreading113712803dre__ading
loading94114613___loading
offloading1842163offloading
onloading1145163_onloading
overloading1647333overloading
persuading1454503persuading
pervading1636303p_ervading
pleading123011443p__leading
plodding13166343p__lodding
prebaking1838063pre_baking
prebidding1783843prebidding
prebinding1696163prebinding
preboiling1546403preboiling
prebooking1944073prebooking
preceding15129363pre_ceding
precleaning1644263precleaning
preclearing1645103preclearing
precluding1644173precluding
precooking1945043precooking
precooling1545963precooling
predating13514653pre_dating
prefacing17118743pre_facing
preforming1846233preforming
prefunding1745233prefunding
preguiding1544493preguiding
preheating16310723preheating
prelecting15310163prelecting
preload1049813preload___
preloaded1335923preload_ed
preloads1157513preload__s
preparing14311643pre_paring
prepaving1787233pre_paving
prepaying1747973pre_paying
preplacing1746003preplacing
presaging1339393pre_saging
preshaping1845423preshaping
presiding13510903pre_siding
presolving1644363presolving
presorting1339983presorting
pretaping1439133pre_taping
pretending1438613pretending
preweaning1645633preweaning
preworking2044233preworking
prodding13189343pr__odding
prologing1338953prolo_ging
prologuing1443863prologuing
prolonging1444803prolonging
reading93327213_re__ading
reboarding1445673_reboarding
recoaling121312453_recoaling
recoating121317463_recoating
recoding122213853_reco_ding
recording131311623_recording
refloating14198323_refloating
reflooding1544053_reflooding
refolding1437453_refolding
regrading121210203_regrading
relacing112516043_rel_acing
relanding112110923_relanding
relating92725443_rel_ating
relaxing162612633_rel_axing
relaying122515153_rel_aying
releasing10411013_releasing
relending112412023_relending
relocating13310873_relocating
relocking16137683_relocking
relooking14167143_relooking
remolding1338163_remolding
repleading1436623_repleading
rereading111212713_rereading
resoaking1439373_resoaking
resodding1237203_resodding
respading1338803_respading
rewording14158543_rewording
spreading1339653spre__ading
treading103515333tre__ading
unloading1137193_unloading
uploading1334663_uploading

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 Filter1786911406030.1561145455.1
2DLD Change Limit140603915.82624133.7
3Display Results91910.0461978.3
 (SQL Overall)178691916.02829643.5
 
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.