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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

67 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
biome9491699(None) 
biomes103815251biomes
brome94421971brome
become123312592become
berme96022942berme
bible95119422bible
bice86235562bi_ce
bide76041502bi_de
bike106532602bi_ke
bikie113915882bikie
bile66147182bi_le
bilge87618912bilge
bima86723832bi_ma
bine66650862bi_ne
binge85125512binge
bio57846082bio__
biog76122322bio_g
biogen9310252biogen
biogs85016112biogs
biont7727162biont
bios66335322bio_s
biota74516822biota
bireme10310142bireme
birle75023632birle
birse74517402birse
bise66437102bi_se
bite66547002bi_te
bize155926292bi_ze
bizone1738602bizone
blame95625492blame
bloke114316632bloke
blume95619892blume
bode75838752b_ode
boite74426322boite
bole66448692b_ole
bomb106927422b_omb
bombe115519312b_ombe
bone65949322b_one
boom87435672boom_
boomed115318132boomed
boomer104618512boomer
booms95427122booms
boomy125421822boomy
booze164718912booze
bore66051332b_ore
broke116019782broke
bromes104719762bromes
bromo95217202bromo
brose75227032brose
brume95817982brume
come87547702_come
dime76237642di_me
diode74716112diode
disme85716242disme
dome77240732_dome
gimme102411342gimme
gnome84213952gnome
home98042442_home
lime66244932li_me
mime85736402mi_me
mome85239352_mome
nome66038422_nome
pome85636692_pome
rime65138882ri_me
some66040382_some
time66235012ti_me
tome67543192_tome

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.310576422.6
2DLD Change Limit53800671.54634799.5
3Display Results67670.0164187.5
 (SQL Overall)178691671.87295454.6
 
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.