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

70 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
crusading134411(None) 
crudding1335722cru_dding
crushing143010052crus_hing
crusting113612792crus_ting
arcading1239763ar_cading
breading123515463br_eading
brigading1445143brigading
brocading1556253brocading
brushing14359963brus_hing
cascading1545673cascading
causing103614413caus__ing
coheading1636623coheading
coleading1338523coleading
corrading1338203corrading
coruscating1644693coruscating
craaling112711353cr_aaling
cradling122411453cr__adling
craning103620303cr__aning
craping124018713cr__aping
crashing143512633cras_hing
crating103725203cr__ating
craving134015733cr__aving
crazing193914583cr__azing
creaking153414123cr_eaking
creaming133413143cr_eaming
creasing113314443cr_easing
creating113921953cr_eating
cremating14312203cremating
cresting114017043cres_ting
crisping13319663cris_ping
croaking153712163cr_oaking
crossing112612693cros_sing
crowding15247933cr_owding
cruising112610153cru_ising
crumbing15267813cru_mbing
crumbling1655083crumbling
crumping15319903cru_mping
crumpling1645323crumpling
crunching17297003crunching
crusade1036053crusad__e
crusaded1244233crusad_ed
crusader1144273crusad_er
crusaders1243453crusaders
crusades1146333crusad_es
crusado1043923crusad__o
crusadoes1243043crusadoes
crusados1153543crusad_os
crutching17216073crutching
curating11314293c_urating
curding113515133c_u_rding
cursing104217033curs__ing
cussing103814273c_us_sing
dreading113712803dr_eading
grading103918713gr__ading
persuading1454503persuading
prefading16149033prefading
presaging1339393presaging
presiding13510903presiding
reading93327213_r_eading
resawing122311433_resawing
resaying122512453_resaying
residing103015483_residing
respading1338803_respading
rushing113817703_rus_hing
rusting83821263_rus_ting
rustling9249983_rustling
trading93517973tr__ading
treading103515333tr_eading
trussing9268653trus_sing
trusting93411653trus_ting

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 Filter1786911486410.423422437.4
2DLD Change Limit148641706.84321721.6
3Display Results70700.0332121.2
 (SQL Overall)178691707.29924481.6
 
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.