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

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

90 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
ulcerates114884(None) 
ulcerate1039731ulcerate_
ulcerated1247741ulcerated
cerates95428232__cerates
lacerates112413762lacerates
macerates132113562macerates
uncrates10314552unc_rates
uncreates11310432uncreates
acerate92818913_acerate_
acerated113113983_acerated
acerbates1347253_acerbates
acetates102013063_acetates
acierates11310793acierates
adulterates1244193adulterates
aerates74627483__aerates
alienates9310683alienates
aliterates101510743aliterates
altercates1247543altercates
alternates1047863alternates
ameerates1149043ameerates
asperates11312543asperates
berates94126853__berates
carates95630603__carates
cerastes101111093__cerastes
cerate84829463__cerate_
cerated103922473__cerated
cerites94823433__cerites
certes84623083__cer_tes
cocreates132611883cocreates
crates85736053__c_rates
creates95225173__creates
curates95323823__curates
deaerates10313623deaerates
decorates12314733decorates
derates84028883__derates
edulcorates1452943edulcorates
elevates111110413el_evates
emeerates1149363emeerates
execrates1839543execrates
federates13310143federates
fulgurates1453613fulgurates
generates10312703generates
iterates81317813_iterates
lacerate102214703lacerate_
lacerated122210673lacerated
legates82917673_l_egates
liberates111012933liberates
librates103412933_librates
literates91415643literates
lucernes1046363lucer_nes
lucubrates1443143lucubrates
lustrates939453lustrates
macerate122314073macerate_
macerated142010523macerated
macerater13259523macerater
maceraters14226633maceraters
moderates12710743moderates
nucleates1148563nucle_ates
numerates11199553numerates
oleates7417833ol_e_ates
operates10515403_operates
picrates122013203pic_rates
racemates1348853racemates
recrates102420353rec_rates
recreates11313343recreates
sclerites1139443sclerites
sulfurates1345753sulfurates
tolerates9312113tolerates
ulcerating1346983ulcerating
ulceration1247263ulceration
ulcerations1346353ulcerations
ulcerative1545173ulcerative
ulcered1037973ulcer__ed
ulcerous1046163ulcer_ous
ulcers839383ulcer___s
ulexites1534943ul_exites
ultimates1148433ultimates
ululates848433ul_ulates
uncrate9415953unc_rate_
uncrated11416313unc_rated
uncreate10311353uncreate_
uncreated12312303uncreated
underages11811083underages
underate9918603underate_
underrates11410553underrates
uprates93814863u__prates
urates65027763u___rates
valerates12310533valerates
venerates12312253venerates
vicarates1487613vicarates

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 Filter1786911486410.1731032896.0
2DLD Change Limit148641906.37623312.6
3Display Results90900.0432093.0
 (SQL Overall)178691906.59227107.3
 
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.