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

74 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
dulses7391365(None) 
dulse65415041dulse_
pulses83818661pulses
avulses1035432avulses
bulges95919322bulges
burses84425512burses
buses75936012bu_ses
busses85023382busses
curses85328272curses
cusses84522772cusses
daises74318982daises
dales66439742dal_es
dalles74222062dalles
deles65139252del_es
delves104917082delves
dieses75218692dieses
disses75225962disses
divulses1244762divulses
doles67843752dol_es
doses65938502d_oses
dosses76126272dosses
douses74928932douses
dowses105718302dowses
druses75517252druses
duces86327472du_ces
dudes75424372du_des
dues56045502du__es
dufuses11436592dufuses
dukes105023472du_kes
dulcet9314492dulcet
dulcets1046282dulcets
dulias71212742dulias
dulled84719422dulled
duller74017702duller
dullest8312632dullest
dulls64523742dul_ls
dulness8307982dulness
dunces95215752dunces
dunes65332172du_nes
dupes86425932du_pes
dures65635922du_res
duress74712062duress
dusks105317252du_sks
dusts65923562du_sts
duties74921902duties
evulses1035042evulses
fuses85628422fu_ses
fusses94920552fusses
guises74216312guises
gules64831042gul_es
mules75034292mul_es
muses75134302mu_ses
musses84624782musses
nurses63919352nurses
pluses83618072pluses
pules74538812pul_es
pulse74219972pulse_
pulsed94013722pulsed
pulser84215192pulser
pulsers94213152pulsers
purses84826372purses
puses75532202pu_ses
pusses84322842pusses
rules55234252rul_es
ruses56136582ru_ses
sudses74114502sudses
susses64221052susses
tules54532792tul_es
tulles63218892tulles
tusses64921242tusses
uses44931112_u_ses
valses94514612valses
wusses93314892wusses
yules84521582yul_es

Search took 7 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 Filter178691825510.360496363.9
2DLD Change Limit82551745.67314551.6
3Display Results74740.0461608.7
 (SQL Overall)178691746.07929394.8
 
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.