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 “flatcars” 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
flatcars134462(None) 
flatcaps1563401flatcaps
flatcar1274611flatcar_
flancard1443372flancard
flancards1543182flancards
flatcap1463652flatca_p
flatters113814202flatters
flatware1444892flatware
flatwares1544772flatwares
flatways1744322flatways
lascars979012_lascars
altars64518153al_t_ars
attars64515313__attars
avatars1036443avat_ars
blathers134713793blathers
blatters104414093blatters
calcars11312653_calcars
clatters103313913clatters
elaters74420193elat_ers
facers115519443f_a_cers
factors12912133f_actors
falters103916473falt_ers
farcers124713443f_arcers
fathers133916503f_athers
fatwas1249053f_atwa_s
faucals12326563f_aucals
feathers143513243feathers
flacks154114533fla_c_ks
flacons1238053fla_cons
flaggers13328073flaggers
flairs95711913fla__irs
flakers143613273fla_kers
flamers124616363fla_mers
flaneurs1133953flaneurs
flangers123311373flangers
flankers15349303flankers
flappers15388383flappers
flashcard1842043flashcard
flashcards1951853flashcards
flashers143912653flashers
flatbeds14364543flatbeds
flatboats1444483flatboats
flatheads1644873flatheads
flatland1264963flatland
flatlands1364303flatlands
flatlets1147373flatlets
flatmate1346393flatmate
flatmates1446193flatmates
flatness1138153flatness
flats86429743flat___s
flattens11357483flattens
flatter103815963flatter_
flattery14338293flattery
flattops1344553flattops
flatus94310783flat__us
flatuses1137173flatuses
flatwash1742423flatwash
flatwork1845393flatwork
flatworks1944703flatworks
flatworm1645183flatworm
flatworms1743963flatworms
flautas1036153flauta_s
flavors1337293fla_vors
flavours1434693flavours
flayers133912033fla_yers
fleecers13325933fleecers
fletchers17335533fletchers
fletches16308853fletches
flitches16388463flitches
flitters114312173flitters
floaters112711513float_ers
flotas94013003flot_a_s
flotsams1343383flotsams
fluters103713683flut_ers
flutters114010823flutters
flytiers14254483flytiers
flytraps1642963flytraps
fracas11311993fra_ca_s
fractals1346133fractals
fracturs13146323fracturs
fraters103517213frat_ers
glancers11408003glancers
klatches17157143klatches
lacers85225253_la_cers
lactams1136953_lactams
lactary1237853_lactary
lahars94013163_la_hars
lancers93616643_lancers
lascar868573_lascar_
latches123320133_latches
lathers104321883_lathers
lazars153812393_la_zars
placard1236783pla_card
placards1345813pla_cards
placers114515263pla_cers
platans93413123plat_ans
plateaus1035533plateaus
platers93924093plat_ers
platters103415283platters
slatches131511533slatches
slaters73123733slat_ers
slathers113914783slathers
tatars64619793_tat_ars
tramcars1245233tramcars

Search took 7 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.420425454.8
2DLD Change Limit1461621046.33023090.4
3Display Results1041040.0462260.9
 (SQL Overall)1786911046.79626293.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.