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

74 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
crackups184312(None) 
crackup1743561crackup_
backups1736172_backups
checkups2142802checkups
cockups1735222c_ockups
crackers164111722crackers
crackles164111272crackles
cracks144817002crack__s
stackups1643312stackups
backup1646613_backup_
brackens16327923brackens
brackets163310433brackets
breakups1642513breakups
cackles153717203c_ackles
cactus104912233c_actu_s
caracks152211563carack__s
caraculs1238033carac_uls
catchups1744383catchups
catsups1135343c_atsups
checkup2043323checkup_
clackers163911703clackers
clacks144516343clack__s
cockup1635713c_ockup_
crack134120533crack___
cracked163514743crack_ed
cracker153114173crack_er
cracking174013903cracking
crackings18346843crackings
crackle153611253crack_le
crackled17428863crackled
crackly18397703crack_ly
cracknel1643703cracknel
cracknels1743433cracknels
crackpot1843833crackpot
crackpots1942833crackpots
cracky175010223crack__y
crakes124921813cra_k_es
cramps125615563cra__mps
craniums1297913craniums
crankles143510153crankles
crankous1435973crankous
cranks125015313crank__s
craps95328643cra___ps
creamcups1741343creamcups
crickets16418123crickets
cricks144316053crick__s
crockets16339543crockets
crocks145118423crock__s
crocus104813173croc_u_s
croups104312553cr__oups
crucks144412583cruck__s
fracturs13146323fracturs
fractus12146593fractu_s
fuckups1832923_fuckups
grackles15309183grackles
kickups1443503_kickups
lockups1534243_lockups
markups1534963_markups
mockups1733343_mockups
pickups1754253_pickups
rackers134320453_rackers
rackets134916873_rackets
rackfuls1744643_rackfuls
racks115028853_rack__s
rakus94413673_ra_ku_s
recoups1188843_recoups
ruckus12407793_rucku_s
stackup1533743stackup_
stickups1643303stickups
teacups1133963teac_ups
trackers143512853trackers
tracks124818843track__s
walkups1633013_walkups
wracks154711113wrack__s

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.423422437.4
2DLD Change Limit146162747.92018454.8
3Display Results74740.0501480.0
 (SQL Overall)178691748.39321290.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.