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

59 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
debruise114391(None) 
debruised1343001debruised
debruises1243631debruises
bruise83412872__bruise
debride1138592debr_ide
debris93311492debr_is_
braise84318753__braise
bruised10389503__bruised
bruiser9349573__bruiser
bruises93212913__bruises
cerise84822043ce_r_ise
ceruse83914523ce_ru_se
cruise84314043__cruise
dearie73319813dear_i_e
dearies83526273dear_ies
debase94014473deb__ase
debouche16123773debouche
debrided1336583debr_ided
debrides1268723debr_ides
debrief1337623debr_ief
debruising1443523debruising
debugs10467823deb_ugs_
debuts93911753deb_uts_
decrease1136563decrease
decries103319803decr_ies
decuries11312223decuries
deerlike1335723deerlike
defuse105712723de_fu_se
degrease1045413degrease
delouse839833delou_se
demise94618323de__mise
demonise11411933demonise
deprive1338303depr_ive
derbies103016053de_rbies
deride84420033de_r_ide
derive103817043de_r_ive
dermis94717163de_rmis_
dermises112512023de_rmises
derries83124623de_rries
derris73615273de_rris_
derrises93012783de_rrises
dervish1436983de_rvish
despise1038683de_spise
detrude936083detru_de
detrudes1036203detrudes
devise104215753de__vise
disguise1046833disguise
druse64817663d__ru_se
ebonise939613_ebonise
febrile1237153febr_ile
hebraize2244453hebraize
nebulise1045743nebulise
peruse84016843pe_ru_se
reburies10311143reburies
reprise92715043repr_ise
reraise7316313re_raise
rerise64325633re_r_ise
unbruised1244763unbruised
zebrine1836463zebr_ine

Search took 9 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 Filter1786911461620.453394461.4
2DLD Change Limit146162598.40617387.8
3Display Results59590.0163687.5
 (SQL Overall)178691598.87520134.2
 
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.