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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

46 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
dueller832983(None) 
dueler74213681due_ler
duelled9359751duelled
duellers9268221duellers
duller74017701du_ller
dweller11297271dweller
fueller10279961fueller
queller16289291queller
crueller1056452crueller
culler84322252cu_ller
cupeller1256102cupeller
dealer74122142d_ealer
delver104913492d_elver
dialler848812dialler
driller84311882driller
droller84110282droller
dueled84813662due_led
duelers83412052due_lers
duelli767002duell_i
duello756782duell_o
duellos845762duellos
dulled84719422du_lled
duxelles1643962duxelles
dwelled12337592dwelled
dwellers12356082dwellers
feller94419552_feller
fueler94313932fue_ler
fuelled11369192fuelled
fuellers11277982fuellers
fuller94220382fu_ller
grueller935332grueller
heller93322512_heller
huller93919102hu_ller
luller63415482lu_ller
muller83820352mu_ller
puller83820812pu_ller
quelled17279272quelled
quellers17237532quellers
seller63824592_seller
sheller103515882sheller
smeller94212782smeller
sneller73512842sneller
speller95415142speller
sweller103012462sweller
teller63519812_teller
yeller94214512_yeller

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit107671462.84337872.3
3Display Results46460.0162875.0
 (SQL Overall)178691463.23255288.1
 
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.