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

147 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
jerboa153563(None) 
jerboas1636161jerboas
jeroboam1943602jeroboam
terbia8311162terbia
yerba101010762yerb_a
aero45435343aer_o_
aerobat9514473aerobat
aerobe8412403aerobe
aerobia939473aerobia
airboat9512133airboat
arbor74818113_arbor
arroba898663arroba
balboa10389963balboa
bebop11410793be_bop
bertha11429173bertha
bilboa10367843bilboa
boa56954033___boa
burbot10815653burbot
carbo94923843carbo_
carbon104919043carbon
carbora11310703carbora
carbos105122263carbos
carboy134914183carboy
ceiba938703ceib_a
cerebra1155933cerebra
ceria75125363cer_ia
cero66329453cer_o_
ceros74726073cer_os
derby114715343derb_y
derma84918523der_ma
ebon66821103_e_bon
elbow10117713_elbow
embow1297563_embow
era35741503_er__a
ergo56420153_ergo_
ergot65422893_ergot
erica7316543_erica
eros45238453_er_os
error53712233_error
feijoa1642223feijoa
ferbam1339003ferbam
feria85922713fer_ia
ferula93011173ferula
fervor1235643fervor
gearbox1742953gearbox
genoa64315823ge_noa
gerbera1034773gerbera
gerbil938343gerbil
harbor11410723harbor
herb94730963herb__
herbal112513493herbal
herbed123513453herbed
herbs105520503herb_s
herby134715313herb_y
hereof123212373hereof
hereon93914363hereon
heriot9422343heriot
herma105318893her_ma
hernia9312293hernia
hero74635783her_o_
heron85025503her_on
heros84930863her_os
jabot14321513j_abot
jargon1448823jargon
jarina134014063jarina
jebel145612143je_bel
jejuna1243243jejuna
jello126716273jello_
jellos134714283jellos
jeon116821443je__on
jereed144012073jereed
jerid132316423jer_id
jerids142810943jerids
jerk154920133jer__k
jerked18479593jerked
jerker17369043jerker
jerkin17258113jerkin
jerks166514893jer_ks
jerky196712423jer_ky
jeroboams2052473jeroboams
jerrid14259143jerrid
jerry155016183jer_ry
jersey1636333jersey
jetbead1742983jetbead
jeton124815403je_ton
jetsom15126143jetsom
jetton1338033jetton
jojoba1441553jojoba
juba134916983j_ub_a
jumbo164311073jumbo_
jumbos17379123jumbos
jura116024893jur__a
juror1239563jur_or
kebob135110923ke_bob
kerb104322723kerb__
kerbed13339703kerbed
kerbs115013673kerb_s
kerria10339923kerria
lesbo739253lesbo_
lesbos837403lesbos
merlon83012353merlon
merlot83217613merlot
nerol51017813ner_ol
pegbox1844013pegbox
perea75026443per_ea
pereia85217983pereia
pereon83517453pereon
pergola1067623pergola
period9314983period
pernod9310453pernod
perron83216623perron
person83517873person
persona92812453persona
proa66229963_pr_oa
rebop9313283re_bop
reroof9315003reroof
sera46141393ser__a
sermon8413553sermon
serosa6313023serosa
serow86720443ser_ow
servo84516683servo_
servos93812723servos
teabox1536013teabox
terbias9310743terbias
terbic10410963terbic
terga63315643ter_ga
termor84412513termor
terra54419673ter_ra
terror63811733terror
turbo71015043turbo_
turbos8910783turbos
turbot8914263turbot
urbia7311143_urbia
vera76828843ver__a
verb96224873verb__
verbal112513663verbal
verbena1235373verbena
verbid122311313verbid
verbose1237753verbose
verbs104614393verb_s
verso85314633verso_
versos93812803versos
xerox1138623xer_ox
yerbas11119293yerbas
zebra1637883ze_bra
zero134822473zer_o_
zeros144918113zer_os

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 Filter1786911127160.376475242.0
2DLD Change Limit1127161477.34315350.1
3Display Results1471470.0463195.7
 (SQL Overall)1786911477.76523012.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.