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

82 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
skibobs154299(None) 
skibob1433421skibob_
kabobs14439302_kabobs
kebobs14427292_kebobs
sibbs96211902s_ib_bs
skidoos1234462skidoos
skimos12548802skimo_s
bibbs84911583_bib_bs
bobs86340653___bobs
cabobs124311893_cabobs
cibols1039523_cibols
jibbs16609743_jib_bs
kababs14409773_kababs
kabob134113933_kabob_
kebabs14418513_kebabs
kebob135110923_kebob_
kibbe135211973_kib_be
kibbes143811193_kibbes
kibbi13449273_kib_bi
kibbis14398473_kibbis
kibeis12469803_kibeis
kibes115521113_kib_es
kiblas1239323_kiblas
kibosh1534263_kibosh
kilos95021473_kilo_s
kinos96626143_kino_s
knobs11519713_k_nobs
kobos115616893_kobo_s
kobs105831083_k__obs
nabobs10388213_nabobs
ovibos1145463ovibo_s
sabots8314703s_abots
sailors73213723sailors
sambos104315193sambo_s
scions82612243sci_ons
seisors73212843seisors
seizors16329013seizors
shibahs15275643shibahs
sibb85921423s_ib_b_
sibs65933543s_i__bs
sibyls1135303s_ibyls
silos56029433s_ilo_s
skatols1135533skatols
skibobber1641153skibobber
skibobbers1751073skibobbers
skiddoos1442113skiddoos
skidoo1136093skido_o
skids104615333ski__ds
skiers104713703ski_ers
skies95026833ski__es
skiffs16327013ski_ffs
skiings12295733skiings
skills104313923ski_lls
skimo116312543skimo__
skimps14488043ski_mps
skims114517193ski__ms
skinks94511653ski_nks
skins94723463ski__ns
skips115616603ski__ps
skirls10449823ski_rls
skirrs10448193ski_rrs
skirts104111503ski_rts
skis84825293ski___s
skites104418043ski_tes
skits94721863ski__ts
skivers14409703skivers
skives134113943ski_ves
skybox2242293skybo_x
skyboxes2442673skyboxes
slobs74419873s__lobs
snibs75613763sni__bs
snobs74716153s__nobs
sobs64941753s___obs
spigots1037793spigots
spinors939423spinors
spinous9310443spinous
stobs75718233s__tobs
suitors73012493suitors
sunbows1236023sunbows
swobs104910893s__wobs
syboes1139343s_yboes
symbols1435523symbols

Search took 7 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.406440125.6
2DLD Change Limit134027825.78323176.0
3Display Results82820.0302733.3
 (SQL Overall)178691826.21928733.1
 
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.