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

146 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
birle7502363(None) 
bible95119411bible
bile66147171bi_le
birl65830461birl_
birled94416991birled
birler85715081birler
birles84920641birles
birls74023161birls
birse74517401birse
aisle55223192aisle
bale66353842b_ale
barbe95328282barbe
barde85330772barde
bare65460522bar_e
barge85631022barge
barley115116762barley
barre75929542barre
barye105021492barye
belle75827832belle
berme96022942berme
biali73419072biali
bialy105119322bialy
bibles104617642bibles
bice86235552bi_ce
bide76041472bi_de
bield84614652bield
biflex1834952biflex
bigly114814752bigly
bike106532592bi_ke
bikie113915882bikie
biles75542142bi_les
bilge87618912bilge
bilk105824412bi_lk
bill67239932bi_ll
billed94224902billed
biller84923482biller
billet86029722billet
billie85019172billie
bills75632862bills
billy105525362billy
bindle94516262bindle
bine66650852bi_ne
binge85125512binge
biome94916992biome
birch124914022birch
bird76128312bir_d
birded104414302birded
birder94915492birder
birdie94013782birdie
birds85421332birds
bireme10310142bireme
birk106326852bir_k
birkie124110132birkie
birks114920302birks
birlers93813002birlers
biro66131202bir_o
biros75325132biros
birr66022352bir_r
birred94713202birred
birrs74917102birrs
birses84717732birses
birth105619872birth
bise66437092bi_se
bite66546992bi_te
bize155926282bi_ze
bogle85821682bogle
bole66448692b_ole
bore66051332bor_e
borne77926792borne
boule74828042boule
brae65639112b_rae
bree67241262b_ree
bribe94820772bribe
bride86425532bride
bridle94115462bridle
brie65837902b_rie
brill74819952brill
brine75132272brine
bugle84721942bugle
burble104617702burble
burgle94815862burgle
burke115122762burke
burl64937182burl_
burled94825382burled
burler84723832burler
burley114715752burley
burls74228852burls
burly104922832burly
burse75527252burse
butle75023102butle
byre95023852byr_e
byrl95716012byrl_
byrled12437172byrled
byrls105711232byrls
carle74535702carle
circle1039702circle
cire65836372cir_e
dire56644142dir_e
dirge75117072dirge
dirl57430022dirl_
dirled84514902dirled
dirls64720502dirls
farle86929242farle
file75446642fi_le
fille84327402fille
fire76245592fir_e
girdle82110462girdle
girl56226552girl_
girlie73711462girlie
girls64518392girls
girly94415292girly
hire75538962hir_e
hiree85427802hiree
hirple11158972hirple
hirsle9159572hirsle
idle55423762_idle
ire36943172_ir_e
isle45121702_isle
kirtle10309472kirtle
lire47845292lir_e
lisle53916722lisle
merle75824372merle
mile66352562mi_le
mille75029132mille
mire66748222mir_e
orle45630462_orle
parle75836162parle
pile65649692pi_le
rifle85518332rifle
rile45650532ri_le
rille55728732rille
sidle65124032sidle
sire46150412sir_e
siree55238812siree
tile45451442ti_le
tire46143352tir_e
tirl45029922tirl_
tirled74714362tirled
tirls54519802tirls
title54721072title
vile76139802vi_le
virile9313432virile
virl76224472virl_
virls85618602virls
wile75944372wi_le
wire75839812wir_e

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.1061685764.2
2DLD Change Limit538001461.78330173.9
3Display Results1461460.0463173.9
 (SQL Overall)1786911461.93592346.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.