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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

54 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
autocrosses139322(None) 
autocross1145092autocro_s_s
motocrosses1552752motocrosses
outcrosses1254702out_crosses
authoresses1443793authoresses
autobusses1243023auto_busses
autocracies1555033autocracies
autoroutes1044803auto_routes
outcrossed1354133out_crossed
outgrosses1144783out_grosses
topcrosses1442273__topcrosses
tutoresses1044373tuto_resses
uncrosses1146153_u_ncrosses
actresses1137934act__resses
albatrosses1351464albatrosses
ancresses1138414a__ncresses
arthroses1248734art_hro_ses
aurochses1444144auroc__hses
authorises1347584author_ises
autobuses1145614auto__buses
autocades1246794autoc__ades
autoclaves1553074autoc_laves
autocoids1246094autoc_o_ids
autocrats1147394autocr__ats
autocrine1146614autocr_ine_
autoerotisms1453144autoerotisms
autofocuses1651934autofocuses
autolyses1276524auto__lyses
autonomies1247954auto_nomies
autopsies1147194auto__psies
autorotates1154704auto_rotates
autoroute945644auto_route_
autosomes1147604auto_so_mes
autotomies1248084auto_tomies
autotrophies1756034autotrophies
autotrophs1586384autotro_phs
backcrosses2172524backcrosses
buttresses1245664but_tresses
crosses94220794____crosses
cutgrasses1343574cut_grasses
incrosses1146034__incrosses
intercrosses1454124intercrosses
lacrosses1145314__lacrosses
motocross1344224motocro_s_s
nutgrasses1143434nut_grasses
outclasses12145134out_classes
outcross1036824out_cro_s_s
outdresses11236824out_dresses
outgrossed1254164out_grossed
outpresses12157254out_presses
recrosses1138374__recrosses
sucroses1039934su__cro_ses
testcrosses1351874testcrosses
uncrossed1236314_u_ncrossed

Search took 10 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 Filter1786911488190.436409841.7
2DLD Change Limit148819548.90616710.0
3Display Results54540.0163375.0
 (SQL Overall)178691549.35819095.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.