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

113 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
kreuzers213206(None) 
kreutzers2241261kreutzers
kreuzer2032351kreuzer_
freezers20307172freezers
kreutzer2141272kreutzer_
arguers8489023argu_ers
arousers84810973arousers
beezers18349243_beezers
brazers184513943br_azers
breakers143810973breakers
breeders11368893breeders
breezes18318693breeze_s
breviers1335923breviers
brewers123811053bre_wers
bronzers19296983bronzers
creamers124111293creamers
creasers103612813creasers
creepers12318623creepers
crozers184111083cr_ozers
dreamers11369003dreamers
dredgers11256093dredgers
dressers9359863dressers
erecters102611613erecters
freers94717303fre__ers
freezer19348523freezer_
freezes193310353freeze_s
fretters113410303fretters
frizers19329553fr_izers
frizzers19335103frizzers
geezers17286513_geezers
grazers175112443gr_azers
greasers93410253greasers
greeters92610113greeters
groupers11358633groupers
grousers93810723grousers
grouters95910063grouters
gruelers936173gruelers
keeners113610783k_eeners
keepers133410983k_eepers
keesters12319593keesters
keggers13357033k_eggers
keglers12277773k_eglers
kelters113813753k_elters
kiesters123310143kiesters
klezmers2341583klezmers
kneaders1384713kneaders
kneelers12226213kneelers
kraters114212333kr_aters
kreeps12427413kre__eps
krewes1337923kre_we_s
krimmers16315673krimmers
krullers1234133krullers
neuters74212263_neuters
perusers10328803perusers
preavers13910263preavers
preeners102712813preeners
prefers123713333pre_fers
preggers12236833preggers
preluders1234423preluders
premiers122911653premiers
pressers103215023pressers
presters103419003presters
presumers1336373presumers
pretzels1934033pretzels
preyers124412363pre_yers
prezes173614693pre_ze_s
prizers183911843pr_izers
pruners93710723pr_uners
queuers16366393queu_ers
razers154919613_r_azers
readers83823763_readers
reamers94221083_reamers
reapers93520453_reapers
rearers74323563_rearers
reavers108320743_reavers
rebukers14435683_rebukers
redders93615343_redders
reducers1147263_reducers
reefers103312593_reefers
reekers113613143_reekers
reelers73520273_reelers
refers93921083_re_fers
refusers11499273_refusers
refuters11449603_refuters
reivers105117083_reivers
reliers75519213_reliers
renders83821673_renders
renters74224813_renters
resters74130403_resters
resumers1038083_resumers
reuses66025523_reuse_s
reutters8138563_reutters
revers94529633_re_vers
rezero1578873_re_zero
rezeros1647453_re_zeros
rousers75220133_rousers
routers74822853_routers
rozzers1535633_rozzers
ruers515019413_r_u_ers
rulers64317093_r_ulers
seizers164112503_seizers
sneezers17246143sneezers
treaders93311833treaders
treaters83615823treaters
trekkers1133803trekkers
troupers10359423troupers
trousers83910623trousers
tweezers20254383tweezers
ureters7311823ure_ters
wheezers23265273wheezers
wreakers15328423wreakers
wreckers17315973wreckers
wresters112711733wresters

Search took 9 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.1561145455.1
2DLD Change Limit1461621138.48317230.0
3Display Results1131130.0462456.5
 (SQL Overall)1786911138.68520574.7
 
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.