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

48 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
fueller1027996(None) 
dueller8329831dueller
feller94419551f_eller
fueler94313931fue_ler
fuelled11369191fuelled
fuellers11277981fuellers
fuller94220381fu_ller
queller16289291queller
crueller1056452crueller
culler84322252cu_ller
cupeller1256102cupeller
dueler74213682due_ler
duelled9359752duelled
duellers9268222duellers
duller74017702du_ller
dweller11297272dweller
faller94621232f_aller
feebler1235822feebler
feeler93215172f_eeler
felled103720302f_elled
fellers104117542f_ellers
fielder11217412fielder
filler94623622f_iller
friller104111742friller
fuehrer1332972fuehrer
fueled104913602fue_led
fuelers103912392fue_lers
fulled103820652fu_lled
fullers103817372fu_llers
fullery13337972fu_llery
fumbler143610812fumbler
furler93616402fu_rler
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.406440125.6
2DLD Change Limit107671483.31332499.5
3Display Results48480.0133692.3
 (SQL Overall)178691483.73247880.8
 
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.