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
screamers1323625(None) 
creamers124111291_creamers
screamer12267871screamer_
streamers11228061streamers
creamer113714082_creamer_
creamery15385972_creamery
creasers103612812_creasers
dreamers11369002_dreamers
reamers94221082__reamers
schemers1576702sche_mers
scrapers125510512scr_apers
screamed13277592screame_d
screams114810612scream__s
screeners1136722screeners
screwers13358052scre_wers
seamers94719432s__eamers
spreaders1236492spreaders
steamers103410872s_teamers
streakers13218122streakers
streamer10239502streamer_
surnamers1143802surnamers
acreages1138363acreage_s
bereavers1446123bereavers
breakers143810973_breakers
cheaters133613503_cheaters
cleaners103610533_cleaners
clearers10349293_clearers
cleavers13398863_cleavers
crammers14369343_crammers
craters95021883_cr_aters
cravers124416543_cr_avers
creamed123913713_creame_d
creameries1446663_creameries
creamier12319063_creamier_
creams104715253_cream__s
creaser94415723_creaser_
creases94020963_crease_s
creates95225173_create_s
creators102814383_creators
creepers12318623_creepers
cremes104517993_cre_me_s
crimmers14298543_crimmers
croakers14288503_croakers
dreamer104110843_dreamer_
framers125113823_fr_amers
gleamers11306563_gleamers
greasers93410253_greasers
increasers1243313increasers
phreakers1834673phreakers
preavers13910263_preavers
readers83823763__readers
reamer84325213__reamer_
reapers93520453__reapers
rearers74323563__rearers
reavers108320743__reavers
roamers93713453__roamers
scalers93817263sc__alers
scammers14339773sc_ammers
scampers143611033sc__ampers
scarers94618503sc__arers
scepters1237783sc_epters
schemer1477953sche_mer_
schemes1489663sche_me_s
scramblers16183543scr_amblers
scramjets2052063scr_amjets
scrams105216623scr_am__s
scraper114513403scr_aper_
scrapes116217663scr_ape_s
scrappers1545843scrappers
scrawlers1434743scrawlers
screaked15246973screake_d
screaks13469353screa__ks
scream104814243scream___
screaming14217823screaming
screechers17143673screechers
screeds106210283scre__eds
screener1037563screener_
screens95212173scre__ens
screes85023963scre__e_s
screwer124410063scre_wer_
screwier1346423screwier_
scribers12307953scr_ibers
scrimpers1554633scrimpers
scripters13116673scripters
scrubbers1543363scrubbers
scummers14277783sc_ummers
sealers74323553s__ealers
seamer84223613s__eamer_
seaters74028933s__eaters
seemers93814333s__eemers
serenaders11204663serenaders
shearers113911323s_hearers
shredders1463703shredders
smearers10308623s_mearers
sneakers12308643s_neakers
speakers14299453s_peakers
spearers103711143s_pearers
sprayers13367053spr_ayers
spreader1137473spreader_
squeakers2284113squeakers
squealers1894453squealers
stealers83412193s_tealers
steamer93313093s_teamer_
stemmers12378443s_temmers
strafers11379903str_afers
strayers113510133str_ayers
streaker12229473streaker_
streambeds1541633streambeds
streamed11258903streame_d
streamier1155763streamier_
streamlets1243073streamlets
streams94713373stream__s
streekers13195793streekers
strewers11409053stre_wers
strummers1333693strummers
surfacers1444323surfacers
surnamer1044883surnamer_
surnames1037273surname_s
swearers11328583s_wearers
sweaters113811053s_weaters
threaders1365733threaders
threapers1444773threapers
treaders93311833_treaders
treaters83615823_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.1701051123.5
2DLD Change Limit1486411257.67319372.0
3Display Results1251250.0631984.1
 (SQL Overall)1786911257.90622601.9
 
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.