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

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

94 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
babiche164457(None) 
babiches1735251babiches
bobeche1643842bobeche
caliche14329952caliche
abide86223713_abi_de
ache96829823_a__che
affiche1844313affiche
amice96122873_amic_e
apache134210773_apache
babble94017113bab_ble
babe86835823bab___e
babied114913513babi_ed
babier103515573babi_er
babies106123653babi_es
babiest114414753babiest
babyish1736513babyish_
baccae12119703ba_ccae
bach116131393ba__ch_
bached145519893ba__ched
baches135426943ba__ches
backache21126063backache
bailee84526013ba_ilee
bailie83818363ba_ilie
baith108023133ba_ith_
baize164717393ba_i_ze
banish111416043banish_
banished14189063banished
banisher13169183banisher
banishes131812463banishes
barbecue14194703barbecue
barbican1445343barbican
barbicel14144963barbicel
barbie105018353barbi__e
baric96125693baric__
barite84224813bari_te
barouche1544173barouche
basic96220523basic__
basics104915123basic_s
batch124620103ba_tch_
batched154114243ba_tched
batcher144414853ba_tcher
batches144019613ba_tches
bathe105822883ba__the
batiste939743batiste
bice86235563__bic_e
blithe115810863b_lithe
bobeches1744483bobeches
boche124216953__boche
bodice11711423bodic_e
brioche14275923brioche
broche133612103b_roche
caboched1844043caboched
cache125122483ca__che
caleche14297943caleche
caliches153812263caliches
calicle113111433calicle
capuche1644433capuche
caroche1469243caroche
ceviche1744143ceviche
cliche133712453_cliche
cubicle1337003cubicle
earache1239323earache
fiche134616743__fiche
ganache1346203ganache
gauche1238553ga_uche
habile11515213habi_le
habitue12266703habitue
labiate91313573labiate
labile8315223labi_le
laich105920713la_ich_
laichs115110893la_ichs
mache125925303ma__che
malice104818483malic_e
manche133515103ma_nche
mastiche1547173mastiche
miche126219243__miche
niche105016793__niche
panache1458423panache
panicle11129983panicle
panoche1456383panoche
pastiche1546933pastiche
potiche1438043potiche
quiche2057903_quiche
rabic93817403rabic__
radicle103510713radicle
sabine84020393sabi_ne
saice75424053sa_ic_e
saithe94713913sa_ithe
sanicle91210263sanicle
seiche11811833_seiche
seviche1545113seviche
subniche1554253subniche
tache106222373ta__che
wavicle1534063wavicle

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit134027947.34318252.3
3Display Results94940.0332848.5
 (SQL Overall)178691947.53223724.2
 
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.