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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
brume9581798(None) 
blume95619891blume
brome94421971brome
brumes106417071brumes
brute75321781brute
grume86218161grume
arame75026622arame
arum66129032arum_
arums75517832arums
berime105317332berime
berme96022942berme
biome94916992biome
bireme10310142bireme
blame95625492blame
blue65328462blu_e
blumed114313642blumed
blumes105917792blumes
boule74828042boule
bouse75931852bouse
brace95629272brace
brae65639112br_ae
brake116025342brake
brave104925502brave
braze165423452braze
brede85520502brede
bree67241262br_ee
breve105317052breve
bribe94820772bribe
bride86425532bride
brie65837902br_ie
brim85629372brim_
brims94721622brims
brine75132272brine
broke116019782broke
bromes104719762bromes
bromo95217202bromo
brose75227032brose
brugh115414292brugh
bruin75818332bruin
bruise83412872bruise
bruit76126722bruit
brumal1049502brumal
brumby15385952brumby
brunet84419292brunet
brung84613912brung
brunt75728752brunt
brush105917472brush
brusk114912432brusk
brut66537962bru_t
bruted95113262bruted
brutes86118682brutes
bruts75922952bruts
brux136315272bru_x
bruxed16466982bruxed
bruxes154811022bruxes
bum75342692b_um_
bumf116126502b_umf
bump106228242b_ump
bums85934592b_ums
burke115122762burke
burse75527252burse
bute66739672b_ute
creme94319322creme
crime94822692crime
crude86018572crude
crumb114313592crumb
crump115616422crump
cruse75726102cruse
drum76521592drum_
drums85415872drums
drupe85012992drupe
druse64817662druse
flume106021172flume
frame105821802frame
frump126912562frump
fume96727632_fume
glume85120462glume
grime85021322grime
grue55825712gru_e
grum75625082grum_
grumes94415552grumes
grump105115312grump
neume74414402neume
plume94819462plume
prime96525602prime
prude84615972prude
prune75119632prune
rime65138882_rime
rube65532012_rube
rude55632782_rude
rue35549262_ru_e
rule49938422_rule
rum56644642_rum_
rumen74419502_rumen
rump86729082_rump
rums64833472_rums
rune45236292_rune
ruse45938932_ruse
spume95817312spume
truce75118692truce
true46725852tru_e
trump95615122trump

Search took 2 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 Filter178691538000.0961861364.6
2DLD Change Limit538001021.59333772.8
3Display Results1021020.0303400.0
 (SQL Overall)1786911021.719103950.6
 
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.