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

135 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
birses8471773(None) 
biases84618431biases
birles84920641birles
birse74517401birse_
bises75435621bi_ses
brises84927611brises
burses84425511burses
abioses9311492abioses
arises65233802arises
arses55733872_arses
baases85218012baases
barbes104526232barbes
bardes95026932bardes
bares75457132bar_es
barges94528252barges
barres84427542barres
baryes116218502baryes
bases75644352b_ases
basses85428302basses
bermes106023002bermes
beses75830722b_eses
biased94012222biased
biasses94911652biasses
bibles104617642bibles
bices95029962bi_ces
bides85536772bi_des
bigoses1039072bigoses
bikes117529472bi_kes
bikies124515162bikies
biles75542142bi_les
bilges94915632bilges
bines76946792bi_nes
binges93923122binges
biomes103815252biomes
birches143412322birches
birded104414302birded
birder94915492birder
birders103913262birders
birdies104016212birdies
birds85421332bir_ds
biremes1138772biremes
birkies133712432birkies
birks114920302bir_ks
birle75023632birle_
birled94416992birled
birler85715082birler
birlers93813002birlers
birls74023162bir_ls
biros75325132bir_os
birred94713202birred
birrs74917102bir_rs
births115713602births
bise66437102bi_se_
bisks115416802bi_sks
bites75641172bi_tes
bizes165923662bi_zes
bizzes163910842bizzes
blisses94911512blisses
bores76448252bor_es
bosses85925402bosses
bourses94014302bourses
bouses84931782bouses
bowses115718862bowses
braes75735052b_raes
brees75632552b_rees
bribes105918532bribes
brides94423512brides
bries74942152b_ries
brines85028852brines
brisks124611402brisks
briss75824272bris_s
brisses94314312brisses
broses86524402broses
buries84633272buries
burkes124421312burkes
bursas85318272bursas
burse75527252burse_
bursts85116242bursts
buses75936012b_uses
busses85023382busses
byres104421382byr_es
carses85233652carses
cires74932912cir_es
corses84433462corses
crises84529432crises
curses85328272curses
dieses75218692dieses
dirges84915102dirges
disses75225962disses
erses55826802_erses
fires85740752fir_es
firsts95110922firsts
frises94124272frises
girshes11248292girshes
gorses74723292gorses
hirees95117292hirees
hires86134342hir_es
hirsel9138682hirsel
hirsels10128342hirsels
hirsles101510072hirsles
hisses94719352hisses
horses94729342horses
ibises83610542ibises
ires45639282_ir_es
irises64221172_irises
kisses104217332kisses
krises105016082krises
marses84827112marses
mioses84318852mioses
mires75640882mir_es
mises74740562mi_ses
misses85130872misses
nurses63919352nurses
parses85534702parses
perses85428062perses
pisses84525082pisses
prises84133172prises
purses84826372purses
rinses64720382rinses
rises55244042ri_ses
sirees64624582sirees
sires55945372sir_es
sises55233832si_ses
sisses64520602sisses
tires55437492tir_es
torses64727952torses
verses94223762verses
vires84529682vir_es
viroses10310532viroses
viruses1039412viruses
vises84427772vi_ses
wires86034912wir_es
wises85633192wi_ses
wisses94619602wisses
worses95522952worses

Search took 5 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 Limit825511354.28319274.1
3Display Results1351350.313431.3
 (SQL Overall)1786911354.95636055.5
 
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.