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

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

51 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
deflowerers185162(None) 
deflowerer1752071deflowerer_
deflowered1842512deflowere_d
deflowers16145642deflow__ers
flowerers1544502__flowerers
beflowered1942903beflowere_d
beflowers17165823beflow__ers
deflower15126073deflow__er_
deflowering1952653deflowering
deliverers1443663de_liverers
deplorers1245463deplo__rers
flowerer1435453__flowerer_
flowerets1544043__flowerets
reflowered1742983reflowere_d
reflowers15125983reflow__ers
beflower16166274beflow__er_
beflowering2042764beflowering
bellowers14177624bellow__ers
ceilometers1545514ceilometers
dayflowers2052414dayflow__ers
decipherers1951784decipherers
declarers1236424decl__arers
deferrers13115154def__errers
deflaters13298704defl__aters
defoamers15285254def_o_amers
defoggers1543054def_o_ggers
deforcers15265504def_o_rcers
deformers15266534def_o_rmers
defrosters1443364defro_sters
delftwares1751334delftware_s
deliverer1344504de_liverer_
delousers1044664de_lo_users
depleters12327544depl__eters
deplorer1136344deplo__rer_
deplores1139534deplo__re_s
deployers1545064deplo__yers
devourers1344094de_vo_urers
dewaterers1442934de_waterers
discoverers1773464discoverers
floorers11227574__flo_orers
flowered1546014__flowere_d
floweret1448084__flowere_t
flowerier1544274__flowerier_
flowerless1642884__flowerless
flowers133413174__flow__ers
flowmeters1843234__flowmeters
recoverers15133614re_coverers
reflower14126844reflow__er_
reflowering1843174reflowering
showerers1545074__showerers
telomeres1146364te_lomere_s

Search took 10 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 Filter1786911488190.420425454.8
2DLD Change Limit148819518.94016646.4
3Display Results51510.0301700.0
 (SQL Overall)178691519.39019029.9
 
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.