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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

104 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
drayage123442(None) 
drayages1344501drayages
damage10410772d_amage
drainage1045782drainage
quayage2044572quayage
ravage1039302_ravage
adage7414053__adage
apanage1036803apanage
barrage10710843barrage
brakeage1544013brakeage
brassage1145283brassage
breakage1544183breakage
brewage1347183brewage
brokage1436673brokage
buoyage1344293buoyage
carnage10311743carnage
cartage10312593cartage
damaged1257453d_amaged
damager1157973d_amager
damages11511273d_amages
daycare1355093d_aycare
daymare1375633d_aymare
dealate83617843dealate
degage92711383d_egage
derange939813dera_nge
diabase1037113diabase
diallage1045233diallage
dockage1535723dockage
dosage82810003d_osage
dotage82711613d_otage
drabble12238883drabble
draftee11379523draftee
drag64825053dr__ag_
dragee84415603dra_gee
dragged11379553dra_gged
dragger10309163dra_gger
draggle1056103draggle
draggy12346823dra_ggy
drags75521113dr__ags
drainages1145503drainages
drake104918303dr__ake
drama85117413drama__
dramady1443553dramady
dramas95814653drama_s
drapable1377573drapable
drape85319633dr__ape
drave95219273dr__ave
drawable1467113drawable
drawee104413823dra_wee
dray85428093dray___
drayed115911393dray_ed
draying123813843draying
drayman1335433drayman
draymen1335233draymen
drays95819773dray__s
dredge9308553dr_edge
dressage1044253dressage
driftage1342933driftage
drudge9317903dr_udge
dryable13237433dryable
dryad10477583dr_ya_d
dryades12395633dr_yades
dryads11436623dr_yads
dunnage9175213dunnage
fromage1336753fromage
garage8314513_garage
garbage1138053garbage
gavage1137193_gavage
gradate9511223gradate
graftage1343683graftage
grange83716203gra_nge
graylag1283113graylag_
graylags1372983graylags
haylage1436443_haylage
lavage1038263_lavage
leafage1194573leafage
leakage1235003leakage
manage93818903_manage
orange74016323ora_nge
presage10312293presage
primage12169143primage
quayages2144213quayages
rage55742353_r__age
ramate83921683_ramate
rampage1237453_rampage
range64728413_ra_nge
ravaged1236493_ravaged
ravager1136553_ravager
ravages1139403_ravages
raya75224823_raya__
rayah116013503_raya_h
rayahs12579193_rayahs
rayas85922053_raya_s
rivage1038843_rivage
savage10410173_savage
scalage103110533scalage
soakage1236103soakage
stravage1245563stravage
thanage11117933thanage
trackage1545653trackage
triage72812893tr_iage
voyage1335473_voyage
warpage1336403warpage
yardage1235733yardage

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271047.17318684.9
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.37524229.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.