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 “biases” 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
biases8461843(None) 
baases85218011baases
bases75644351b_ases
biased94012221biased
biasses94911651biasses
birses84717731birses
bises75435621bi_ses
abases85720772abases
abioses9311492abioses
aliases7914492aliases
babes95834112b_abes
baizes174315052baizes
bakes117035372b_akes
balases93815432balases
bales76250082b_ales
banes74945582b_anes
bares75457132b_ares
base64847022b_ase_
based85331582b_ased
baser74828922b_aser
basest84720492b_asest
bashes115631392b_ashes
basis75429862b_asis
basks115621762b_asks
bass66146782b_as_s
basses85428302basses
bastes85330382b_astes
basts75936932b_asts
bates75846342b_ates
beasts84519722beasts
beses75830722b_eses
bialies93618412bialies
bialis83617162bialis
bialys11387912bialys
bias64738152bia__s
biasness1035812biasness
biassed10418702biassed
bibles104617642bibles
bices95029962bi_ces
bides85536772bi_des
bifaces1448062bifaces
bigoses1039072bigoses
bikes117529472bi_kes
bikies124515162bikies
biles75542142bi_les
bilges94915632bilges
bines76946792bi_nes
binges93923122binges
biogases1136142biogases
biomes103815252biomes
birles84920642birles
birse74517402birse_
bise66437092bi_se_
bisks115416802bi_sks
bites75641172bi_tes
bizes165923662bi_zes
bizzes163910842bizzes
blades95221252blades
blames105121862blames
blares85021632blares
blase75524232blase_
blasts85116772blasts
blazes174817352blazes
blisses94911512blisses
boasts85017922boasts
bolases93315002bolases
bosses85925402bosses
bouses84931782bouses
bowses115718862bowses
braces108427772braces
braes75735052bra_es
braises93818872braises
brakes124923122brakes
brashes124518462brashes
brass75428022bras_s
brasses93818352brasses
braves115524082braves
brazes175522192brazes
brises84927612brises
brisses94314312brisses
broses86524402broses
burses84425512burses
buses75936012b_uses
busses85023382busses
cases75048382_cases
ceases84427072ceases
chases115128232chases
crases85532312crases
daises74318982daises
dieses75218692dieses
disses75225962disses
eases56041612_eases
erases64425402erases
eyases94513682eyases
feases95422922feases
gases65633992_gases
hisses94719352hisses
ibises83610532ibises
kinases113511122kinases
kisses104217332kisses
kvases13467102kvases
lases54944762_lases
leases65428112leases
liaises7311052liaises
lianes63819322lianes
ligases82310702ligases
lipases9209482lipases
lyases95211872lyases
miasms1097382miasms
mioses84318852mioses
mises74740562mi_ses
misses85130872misses
myases113711552myases
myiases1235492myiases
oases55330982_oases
pases75346502_pases
peases85229472peases
phases114618402phases
pisses84525082pisses
prases84429022prases
raises64826542raises
rases55447212_rases
rinses64720382rinses
rises55244042ri_ses
sises55233832si_ses
sisses64520602sisses
stases64225562stases
teases65426272teases
ukases10358062ukases
upases84112902upases
urases63723562urases
vases84626262_vases
vises84427772vi_ses
wises85633192wi_ses
wisses94619602wisses

Search took 4 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.220812231.8
2DLD Change Limit825511352.92328241.9
3Display Results1351350.0462934.8
 (SQL Overall)1786911353.18956033.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.