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

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

69 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
trasher10441613(None) 
brasher124515241brasher
crasher124616161crasher
rasher95024121_rasher
thrasher1455741thrasher
trashed113514701trashed
trashers113013641trashers
trashes104119261trashes
trashier113210101trashier
basher115123812_basher
brashes124518462brashes
brashier13389932brashier
brasier94516752brasier
brusher123813002brusher
clasher124615512clasher
crashed134214212crashed
crashers134013232crashers
crashes124618402crashes
crasser94114342crasser
crusher124412322crusher
dasher104318982_dasher
eraser64216332eras_er
flasher133914062flasher
fresher132612642fresher
gasher104320372_gasher
grasper10389792grasper
harsher13310362harsher
kasher134915032_kasher
lasher94824532_lasher
masher114123202_masher
plasher124215032plasher
quasher19198622quasher
raser55633412_ras_er
rashers104020912_rashers
rashes95330152_rashes
rasper83917332_rasper
raster64731442_raster
rather94319742_rather
rusher94019652_rusher
slasher104515332slasher
smasher123911022smasher
swasher134011512swasher
tarsier74119252tarsier
taster64930572t_aster
teacher123714832teacher
teaser65421522teas_er
thrashed1555362thrashed
thrashers1565312thrashers
thrashes1487652thrashes
thresher1455822thresher
toaster74414462toaster
tracer84820232tra_cer
trachea12311682trachea
tracker133515172tracker
trader75218762tra_der
trailer73015392trailer
trainer73316792trainer
tramper113812162tramper
transfer1138432transfer
trapper113912802trapper
trash86119762trash__
trashmen1346562trashmen
trashy12509052trash_y
trasses74819322trasses
trawler104011902trawler
trusser74010262trusser
truster73114312truster
tryster10369512tryster
washer124720392_washer

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit107671693.50030763.1
3Display Results69690.0164312.5
 (SQL Overall)178691693.89245912.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.