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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

124 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
alibiing113532(None) 
aliasing9310072aliasing
aliening91510892aliening
aligning10158532aligning
alining81917042ali_ning
abiding11510503abi_ding
abying124410413a__bying
adhibiting1742773adhibiting
agisting1038243agisting
aiblins9311473a_iblins
aiding84423613a_i_ding
ailing74331013a_i_ling
aiming94320843a_i_ming
airing74927503a_i_ring
airting83616303a_irting
alarming1138583alarming
albinic1136853al_binic
albino839933al_b_ino
alerting91312383alerting
aliasings1043653aliasings
alibi7514233alib_i__
alibied1038143alib_ied
alibies9313323alib_ies
alibis8311073alib_i_s
alighting1446413alighting
allaying12339303allaying
alleging1038473alleging
allowing12369093allowing
alloying12339143alloying
alluding1036953alluding
alluring939073alluring
allying113011663al_lying
altering91917113altering
ambling121411793a_mbling
arabizing2147963arabizing
arising83619973ari_sing
audibling1343333audibling
aviating12311013aviating
bibbing11299613_bibbing
blabbing12266723blabbing
blebbing12265673blebbing
blinding123210163blinding
blinking153510623blinking
blipping15306803blipping
blissing1136873blissing
blitzing2035903blitzing
blobbing12246923blobbing
blubbing12257013blubbing
bribing123111043brib_ing
clicking173610983clicking
climbing15205983climbing
clinging122910913clinging
clinking153611663clinking
clipping15349153clipping
cliquing2035363cliquing
clubbing15266513clubbing
cribbing15276843cribbing
dibbing133110893_dibbing
dribbing14325883dribbing
eliciting1237773eliciting
eliding93414343eli_ding
fibbing15339463_fibbing
flicking184110043flicking
flinging133310053flinging
flinting123412343flinting
flipping16307663flipping
flirting12319013flirting
fliting113514613fli_ting
flitting123010883flitting
flubbing16275883flubbing
gibbing13339373_gibbing
gibing103712353_gib_ing
gliding103911843gli_ding
gliming113310133gli_ming
glinting103210053glinting
glitzing1934973glitzing
globing113210003glob_ing
jibbing19338063_jibbing
jibing16379623_jib_ing
laicising1245623laicising
laicizing2145713laicizing
lairing83715343lai_ring
lambing123412413lamb_ing
liaising937913_liaising
libeling1139873_libeling
licking144118283_licking
lidding103611433_lidding
lifting113313273_lifting
liking114319583_li_king
lilting83515383_lilting
limbing123410423_limbing
liming94021243_li_ming
limiting1138813_limiting
limning103710323_limning
limping124614113_limping
lining74526803_li_ning
linking123818253_linking
linting83820983_linting
lipping123016073_lipping
lisping103412753_lisping
listing84020593_listing
living104318323_li_ving
lobbing123110913_lobbing
lubing94114043_lub_ing
maligning13145583maligning
nibbing12339553_nibbing
plinking153611243plinking
ribbing123111953_ribbing
salifying1636333salifying
salinizing2047433salinizing
sibling10814423_sibling
slabbing13287783slabbing
slicing103514643sli_cing
slicking153712593slicking
sliding93114553sli_ding
sliming102913953sli_ming
slimming13288093slimming
slinging103312863slinging
slinking133412983slinking
sliping103314413sli_ping
slipping133510663slipping
slitting93012583slitting
slubbing13248033slubbing
snibbing13295893snibbing

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 Filter1786911461620.1531167915.0
2DLD Change Limit1461621247.22020244.0
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.41924085.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.