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

112 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
skibob143342(None) 
skibobs1542991skibobs
kabob134113932_kabob
kebob135110922_kebob
sibb85921422s_ib_b
skidoo1136092skidoo
skimo116312542skimo_
skimos12548802skimos
skybox2242292skybox
akimbo1443393akimbo_
bibb75819213_bib_b
bob76755673___bob
cabob114616813_cabob
cibol9512023_cibol
jibb155816743_jib_b
kabab134814443_kabab
kabobs14439303_kabobs
kebab134312003_kebab
kebobs14427293_kebobs
kibbe135211973_kibbe
kibbi13449273_kibbi
kibe106523453_kib_e
kibei114311533_kibei
kibes115521113_kibes
kibla1139833_kibla
kibosh1534263_kibosh
kilo86028673_kilo_
kilos95021473_kilos
kino86233623_kino_
kinos96626143_kinos
knob107417013_k_nob
kob99442383_k__ob
kobo107422103_kobo_
kobos115616893_kobos
nabob93913743_nabob
ovibos1145463ovibos
sabot7931783s_abot
sailor63113753sailor
sambo95118013sambo_
sambos104315193sambos
scion72214993sci_on
seisor63712343seisor
seizor15428533seizor
shibah14387473shibah
sib56850313s_i__b
sibbs96211903s_ibbs
sibs65933543s_ib_s
sibyl1037113s_ibyl
silo46037913s_ilo_
silos56029433s_ilos
skatol1035723skatol
ski74925693ski___
skiable1338883skiable
skibobber1641153skibobber
skid95720933ski__d
skiddoo1342553skiddoo
skiddy1533633skiddy
skidoos1234463skidoos
skids104615333ski_ds
skied104417753ski_ed
skier95119593ski_er
skiers104713703skiers
skies95026833ski_es
skiey125012893ski_ey
skiff153612803ski_ff
skiffs16327013skiffs
skiing113610193skiing
skill94316723ski_ll
skills104313923skills
skim105322513ski__m
skimp135411323ski_mp
skimps14488043skimps
skimpy17475723skimpy
skims114517193ski_ms
skin85927533ski__n
skink85916853ski_nk
skinks94511653skinks
skinny13456613skinny
skins94723463ski_ns
skint95629223ski_nt
skip105421753ski__p
skips115616603ski_ps
skirl96012913ski_rl
skirls10449823skirls
skirr94810543ski_rr
skirrs10448193skirrs
skirt95624663ski_rt
skirts104111503skirts
skis84825293ski__s
skit85437533ski__t
skite95120053ski_te
skited114313483skited
skites104418043skites
skits94721863ski_ts
skive124614113ski_ve
skived14429893skived
skiver134612103skiver
skives134113943skives
skivvy1932783skivvy
slob66029423s__lob
snib66522983sni__b
snibs75613763snib_s
snob65825593s__nob
sob57857943s___ob
spigot9312603spigot
spinor839943spinor
stob66724613s__tob
suitor63311053suitor
sunbow1145823sunbow
swob95218633s__wob
sybo9714743s_ybo_
symbol1336083symbol

Search took 6 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.373479064.3
2DLD Change Limit1127161124.83023336.6
3Display Results1121120.0303733.3
 (SQL Overall)1786911125.23334147.0
 
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.