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

125 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
screamers1323626(None) 
creamers124111311_creamers
screamer12267881screamer_
streamers11228071streamers
creamer113714092_creamer_
creamery15385982_creamery
creasers103612842_creasers
dreamers11369002_dreamers
reamers94221082__reamers
schemers1576712sche_mers
scrapers125510532scr_apers
screamed13277602screame_d
screams114810622scream__s
screeners1136732screeners
screwers13358062scre_wers
seamers94719432s__eamers
spreaders1236502spreaders
steamers103410872s_teamers
streakers13218132streakers
streamer10239512streamer_
surnamers1143802surnamers
acreages1138373acreage_s
bereavers1446123bereavers
breakers143810973_breakers
cheaters133613513_cheaters
cleaners103610543_cleaners
clearers10349303_clearers
cleavers13398873_cleavers
crammers14369353_crammers
craters95021893_cr_aters
cravers124416563_cr_avers
creamed123913713_creame_d
creameries1446673_creameries
creamier12319063_creamier_
creams104715253_cream__s
creaser94415743_creaser_
creases94020963_crease_s
creates95225203_create_s
creators102814413_creators
creepers12318633_creepers
cremes104517993_cre_me_s
crimmers14298543_crimmers
croakers14288523_croakers
dreamer104110843_dreamer_
framers125113823_fr_amers
gleamers11306563_gleamers
greasers93410253_greasers
increasers1243313increasers
phreakers1834673phreakers
preavers13910263_preavers
readers83823773__readers
reamer84325213__reamer_
reapers93520453__reapers
rearers74323563__rearers
reavers108320743__reavers
roamers93713463__roamers
scalers93817263sc__alers
scammers14339773sc_ammers
scampers143611033sc__ampers
scarers94618513sc__arers
scepters1237793sc_epters
schemer1477963sche_mer_
schemes1489663sche_me_s
scramblers16183543scr_amblers
scramjets2052063scr_amjets
scrams105216623scr_am__s
scraper114513423scr_aper_
scrapes116217663scr_ape_s
scrappers1545863scrappers
scrawlers1434753scrawlers
screaked15246983screake_d
screaks13469363screa__ks
scream104814253scream___
screaming14217833screaming
screechers17143683screechers
screeds106210293scre__eds
screener1037573screener_
screens95212183scre__ens
screes85023973scre__e_s
screwer124410073scre_wer_
screwier1346433screwier_
scribers12307963scr_ibers
scrimpers1554643scrimpers
scripters13116683scripters
scrubbers1543373scrubbers
scummers14277783sc_ummers
sealers74323553s__ealers
seamer84223613s__eamer_
seaters74028943s__eaters
seemers93814333s__eemers
serenaders11204663serenaders
shearers113911323s_hearers
shredders1463713shredders
smearers10308623s_mearers
sneakers12308643s_neakers
speakers14299453s_peakers
spearers103711143s_pearers
sprayers13367053spr_ayers
spreader1137483spreader_
squeakers2284113squeakers
squealers1894453squealers
stealers83412213s_tealers
steamer93313093s_teamer_
stemmers12378443s_temmers
strafers11379913str_afers
strayers113510143str_ayers
streaker12229483streaker_
streambeds1541633streambeds
streamed11258903streame_d
streamier1155763streamier_
streamlets1243073streamlets
streams94713373stream__s
streekers13195803streekers
strewers11409063stre_wers
strummers1333693strummers
surfacers1444323surfacers
surnamer1044883surnamer_
surnames1037273surname_s
swearers11328583s_wearers
sweaters113811063s_weaters
threaders1365743threaders
threapers1444773threapers
treaders93311843_treaders
treaters83615843_treaters
wreakers15328423_wreakers

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411256.58022589.8
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.06225303.2
 
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.